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

["Bauer, Michael D" <Michael.Bauer@MW.BOEING.COM>]

The -Mfile is a flag.  Where -M is the flag followed by a file name.

So for example to run at command line you enter "sqr mikessqr.sqr
-Mdefaultfile.dat"

In the file default file you need to set some defaults.
So in your file you need something like
SQLSIZE=12000

Hope that helps

-----Original Message-----
From: O'Dorisio, Steve [mailto:Steven.O'Dorisio@MMS.GOV]
Sent: Wednesday, April 25, 2001 10:15 AM
To: SQR-USERS@list.iex.net
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