You have 375 characters in the truncated version of your text, which would not suggest any system limitation, and I haven't heard of any string variable max length. Suggest you check your code carefully for an inadvertent action that is cutting off your final characters. As a preliminary test for this, try excluding one of the earlier phrases being concat'd into the string and see if the cut-off occurs at same place...
-----Original Message-----
From: Krishnan Sarangarajan [mailto:ksaranga@RUAN.COM]
Sent: Wednesday, February 02, 2000 11:06 AM
To: SQR-USERS@list.iex.net
Subject: Re: Number of characters in a string...
Hello Users! I am trying to run an SQR that builds a dynamic SQL statement.
We are using SQR3 here.
I am able to build the statement successfully by placing it in a single
variable. I am unable to display all the contents of this variable.
The following is the statement that I am able to display :
(c.paygroup in ('XRB','XRE','XRH') and c.week_nbr = '05' and
c.al_process_effdt = '01-FEB-2000') or (c.paygroup in
('XRA','XRC','XRD','XRF','XRG','XRM') and c.week_nbr = '05' and
c.al_process_effdt = '01-FEB-2000') or (c.paygroup = 'XRR' and c.week_nbr =
'04' and c.al_process_effdt = '26-JAN-2000') or (c.paygroup = 'WZF' and
c.week_nbr = '05' and c.al_process_effdt = '01-FEB-20
What I am looking for is as follows :
(c.paygroup in ('XRB','XRE','XRH') and c.week_nbr = '05' and
c.al_process_effdt = '01-FEB-2000') or (c.paygroup in
('XRA','XRC','XRD','XRF','XRG','XRM') and c.week_nbr = '05' and
c.al_process_effdt = '01-FEB-2000') or (c.paygroup = 'XRR' and c.week_nbr =
'04' and c.al_process_effdt = '26-JAN-2000') or (c.paygroup = 'WZF' and
c.week_nbr = '05' and c.al_process_effdt = '01-FEB-2000')
The difference between the two statements is shown in red.
Furthermore, I am getting errors from the SQL statement because the last 3
characters of the "where" clause is being cut and the result is - "Couldn't
set up cursor".
The contents of our ALLMAXES.max file is as follows :
DYNAMICARGS=300
NUMVARIABLES=700
POSITIONS=3000
PROGLINEPARS=20000
PROGLINES=5000
QUERIES=200
QUERYARGS=1000
SQLSIZE=8000
STRINGSPACE=30000
SUBVARS=5000
VARIABLES=2600
WHENS=1500
FORWARDREFS=2000
EXPRESSIONSPACE=15000
I have tried bumping up the values of SQLSIZE, STRINGSPACE &
EXPRESSIONSPACE, but to no luck.
I would appreciate any suggestions that I can get so that I can get my
report to work.
Thanks in advance for your help.
Sincerely,
Krishnan
Note : I would prefer to use the max file to make my report work. My last
option would be to break down by SQL statement into 4 where clauses so that
I can make my report work.
Ruan Transportation Management Systems
(515) 245-5655 [P]
(515) 247-2065 [F]
ksaranga@ruan.com