Error Num -229
Program stopped at "my4gl.4gl", line number 52.
SQL statement error number -229.
Could not open or create a temporary file.
Why can I not create this temp file?
DBTEMP is set to HOMEDIR$/tmp
Changed DBTEMP to INFORMIXDIR$/tmp and
no success.
.....and YES I have permissions.
lineno. 52 is...
FOREACH c_1 INTO pa_1.*
where pa_1 is an array with 6 items
and c_1 is a CURSOR FOR
SELECT * FROM tb_1
NOTE: tb_1 has some 400,000 active records.
is this to large of a select?
should I break it down into sets?
Thanks in advance,
Bill