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

[Chantelle Wall <cwall@MAIL.RATH.PEACHNET.EDU>]

Before you go through the trouble of changing your SQLSIZE, I would make sure
that you have all of your "END" statements.  If you are missing one, you will
get this error because it is trying to read everything in between your begin and
the next end.

"O'Dorisio, Steve" wrote:

> 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