Re: -M file error: "(SQR 1302) SQL buffer too small; use -Mfile t o in crease SQLSIZE"

["O'Dorisio, Steve" <Steven.O'Dorisio@MMS.GOV>]

Thanks for the responses, I think we have what we need.  I am running the
program now, and it seems to be doing OK.
Thanks again,
STeve

-----Original Message-----
From: Troy Wiechman [mailto:WIECHTJ@KELLYSERVICES.COM]
Sent: Wednesday, April 25, 2001 9:40 AM
To: SQR-USERS@list.iex.net
Subject: Re: -M file error: "(SQR 1302) SQL buffer too small; use -Mfile
to in crease SQLSIZE"


Your sql statement is too large for the default size of a sql statement.
There
is a variable in the sqr.ini that could be
increased.  SQLSIZE=4000

Or create a file

and put one line in it -> SQLSIZE=10000

Then on the command line, use the -M Flag to point at the file you created.

sqr program.sqt logon_info -RT -Mprogram.sqm


Troy





"O'Dorisio, Steve" <Steven.O'Dorisio@MMS.GOV> on 04/25/2001 11:15:18 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Troy Wiechman/HQ/USA/Kelly)
Subject:  -M file error: "(SQR 1302) SQL buffer too small; use -Mfile to in
      crease SQLSIZE"



I am getting the following error:

"(SQR 1302) SQL buffer too small; use -Mfile to increase SQLSIZE.

SQR: Program Aborting."

My questions:
1) What is the -Mfile?
2) How do I change the SQLSIZE?
3) Do I need to include it as a Report Argument when I execute my SQR?  Or
do I need to include a command within the SQL section? Or do I need to
create a separate file (SQC, SQR, ???) that my program calls?  Sample code
and/or a brief summary would probably be sufficient.

Research thus far:
-SQR error 1302 = 'The SQL statement exceeds the size of the internal SQL
buffer.  Use the -Mfile flag on the command line to specify a file
containing an entry that increases the currently defined value.' *What
command line?
-According to SQRUG FAQ the default SQLSIZE is 4000, max is 65535.  *I just
don't know where to set this?
-Doesn't seem to work as a Report Argument when(unless I am doing it wrong).

Background:
-Using SQR for batch process (load of database table).
-Using a SQL Select Statement as the main loop (loading each row, one at a
time).
-Using Oracle 8i database.
-Using both PeopleSoft and Brio, but no gurus/resources on site to help out.
-Have "SQR Language Reference Guide" and "SQR in PeopleSoft and Other
Application"

Thank you,
Steve O'Dorisio
steven.o'dorisio@mms.gov