Re: EXPRESSIONSPACE

[Yogesh Kulkarni <yskulkarni@HOUSEHOLD.COM>]

Hi Mike,

     I have encountered a similar error, typically when a "Begin-SELECT"
does not have a corresponding "End-SELECT"(or Begin-SQL does not have an
End-SQL"). We are using SQR4.3, Oracle 8 on Solaris. The error message is a
bit misleading.

Hope that helps.

Regards,
Yogesh





"Discussion of SQR, Brio Technology's database reporting language"
<SQR-USERS@list.iex.net>
07/02/2001 04:26 PM


Please respond to sqr-users@list.iex.net



To:   SQR-USERS@list.iex.net
cc:
Subject:  EXPRESSIONSPACE


Sqr ver 3.0.7.3, OS: HP-UX, DB: Informix

I am getting the following error when using the let command.
"(4038) out of space while processing expression; Use -Mfile to increase
EXPRESSIONSPACE"

I am trying to string several variables into one.  After some debugging, I
have found that if the total length of the string is 3275 character or less
it works fine.  Once I increase the string size to 3276 or more, I get the
above message.  I have read several posting and I have tried the following
and I still get the message.  I have included a copy of my allmaxes.max

1)       Removed EXPRESSIONSPACE from allmaxes.max
2)       Change the size of EXPRESSIONSPACE to 10000
3)       Change the size of EXPRESSIONSPACE to 8000.
4)       Specified -Mfile option on the command line.

If anyone has other suggestions, I would greatly appreciate it.

Thank you,
Mike

!
!CURSORS         Max number of database cursors (SQLBase only)
!DYNAMICARGS     Max number of dynamic SQL arguments
!EXPRESSIONSPACE Max length of temp string storage during LET operations
!FORWARDREFS     Max number of &column forward references
!NUMVARIABLES    Max number of numeric variables and literal values
!ONBREAKS        Max number of ON-BREAK LEVEL=values per SET
!POSITIONS       Max number of placement parameters, "(10,5,30)"
!PROGLINEPARS    Max number of arguments for all program lines
!PROGLINES       Max number of program lines (SQR commands)
!QUERIES         Max number of BEGIN-SQL and BEGIN-SELECT paragraphs
!QUERYARGS       Max number of bind variables for all SQL statements
!SQLSIZE         Max length of a SQL statement in characters
!STRINGSPACE     Max length of string space for program line arguments
!SUBVARS         Max number of run-time substitution variables
!VARIABLES       Max number of variables, literals and database columns
!WHENS           Max number of WHEN arguments allowed per EVALUATE
!
!CURSORS=20
DYNAMICARGS=500
EXPRESSIONSPACE=65535
FORWARDREFS=1000
NUMVARIABLES=1100
ONBREAKS=75
POSITIONS=5000
PROGLINEPARS=65535
PROGLINES=10000
QUERIES=400
QUERYARGS=2300
SQLSIZE=10000
STRINGSPACE=60000
SUBVARS=2000
VARIABLES=5000
WHENS=1000