Re: error: Out of param storage

[Kimberly Lawrence <Kimberly_Lawrence@CCNOTES.CCITY.COM>]

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!

pic11361.pcx