Re: What is QUERYARGS means ?

[Ray Ontko <rayo@ONTKO.COM>]

KH Hee,

It is true; QUERYARGS cannot be increased beyond 65535.
QUERYARGS is an SQR initialization parameter which tells
SQR how much space to reserve for arguments (bind variables)
which appear in your BEGIN-SQL or BEGIN-SELECT statements.

I'd be surprised if you have more than 65000 arguments to
the SQL in your report program.  Is it possible that you
have a lot of SQL in #include files but your program
only uses a few of the SQL statements?  If so, I can
suggest a work-around.

Ray
> Hello,
> I need help urgently. I am running SQR with the following environment
> 1. SQR:  Structured Query Report Writer  V2.27a
> 2. HP Unix
> 3. Oracle version 7
>
> I have a program which has been running fine for more than more than
> one year. Now I have received the following error when I try to run the
> program (abc.sqr) to process data in Oracle Database as below :
>
> << ===== Start : execution log ===== >>
> $> more setting.para
> QUERYARGS = 65535
> $>
> $> sqr abc / -msetting.para
> SQR:  Structured Query Report Writer  V2.27a
> Copyright (C) 1986-89  SQ Software  All Rights Reserved
>
> Out of query arguments; use -Mfile to increase QUERYARGS
> $>
> << ===== End : execution log ===== >>
>
> When I tried to increase the value of QUERYARGS to any number greater
> than 65535 I received the following error :
> Maximum dimension for 'queryargs' in -Mfile is 65535.
>
> Is anyone know what is the QUERYARGS means? Where can I find the list
> of all parameter setting and what each of these means? How can I
> rectify this issue?
>
> Any hints or help is really appreciated. Anyway, thank for you time to
> finish this mail.
>
> Regards,
> KH Hee.
> CWT Distribution Ltd.
> TEL : (65) 2626-888
> DID : (65) 2626-847
> Fax : (65) 2622-116
> Email : khhee@cwt.com.sg
> Web : http://www.cwt.com.sg
>

----------------------------------------------------------------------
Ray Ontko       |  Ray Ontko & Co  |  "Time for a new signature line."
rayo@ontko.com  |  Richmond, In    |  See us at http://www.ontko.com/