[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
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