Re: error: Out of param storage

["Derry, Denny" <Denny.Derry@NMB.NORWEST.COM>]

The max value for PROGLINEPARS is 65535 (At least according to my SQR 3.x
manual).

PROGLINEPARS=65535

Try that.

HTH,
-Denny

> -----Original Message-----
> From: Kimberly Lawrence [SMTP:Kimberly_Lawrence@CCNOTES.CCITY.COM]
> Sent: Tuesday, November 10, 1998 12:40 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: error: Out of param storage
>
> Robert,
>
> I tried this but it I'm still getting the same error message.  The SQR I'm
> trying to execute only has 1889 lines in it and according to my handy
> reference manual the SQR default is 2500 lines.  I tried creating the file
> and running it the way you suggested anyway but it didn't make any
> difference.  I even upped the number of lines to 10,000 just to see if I
> could get it going but it didn't work either.
>
> Thanks for the suggestion, this is a learning experience.  If anyone out
> there has any other thoughts on this I'd love to hear them.
>
> Thanks again!
>
>
>
>
>  (Embedded
>  image moved   Robert Leonard <rleonard @ SOURCEINFORMATION.COM>
>  to file:      11/10/98 11:57 AM
>  pic11361.pcx)
>
>
>
>
> Please respond to SQR-USERS@USA.NET
>
> To:   Multiple recipients of list SQR-USERS <SQR-USERS @ list.iex.net>
> cc:
> Subject:  Re: error: Out of param storage
>
>
>
>
> Kimberly,
>
> Just create a text file that has the following line (without the quotes):
>
> "proglines=XXXX"     ! where XXXX is the number of program lines you are
> trying to compile and process.
>
> Then reference that text file (mymem.mem) from you ops command line...
> ex:
>
> Sqr fn.sqr username/password -Mmymem.mem
>
> Note: no space between the "-M" and the filename (common error).
>
> Check your manual on process limits.....
>
> Bob leonard
>
>
> -----Original Message-----
> From:   Discussion of SQR,             SQRIBE Technologies's database
> reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Kimberly
> Lawrence
> Sent:   Tuesday, November 10, 1998 11:14 AM
> To:     Multiple recipients of list SQR-USERS
> Subject:        error: Out of param storage
>
> Hi All,
>
> I'm using SQR version 3 on an Informix database and I'm having trouble
> executing an SQR from within another SQR.  This is the command that I'm
> using with the call system using syntax:
>
>      sqr -pb /home/fsdev/sqr/fin9020.sqr dev 0 0 0 KIML Test
>
> When I type this command on the command line it works fine but when it is
> called from within the SQR I get the following error message:
>
>      SQR: Structured Query Report Writer V3.0.18.1
>      Copyright (C) SQRIBE Technologies, 1994-97.  All Worldwide Rights
> Reserved.
>
>      (SQR 4401) Out of param storage; use -Mfile to increase PROGLINEPARS.
>
>      SQR: Program Aborting.
>
> I'm sure I'm missing something here I'm just not sure what it is.  If
> anyone has any thoughts on this please let me know.
>
> Thanks in advance!
>  << File: pic11361.pcx >>