View previous topic :: View next topic
|
Author |
Message |
rajesh1183
New User
Joined: 07 Jan 2008 Posts: 98 Location: Hyderabad
|
|
|
|
Hi All
I have a requirement like reading an input file with policy number as a key and update a column of a DB2 table..... So, instead of writing a MACRO, I have tried the below code with CALL EXECUTE stmt...
Code: |
DATA _NULL_;
INFILE IN01;
INPUT @001 POLICY_NUM $CHAR019.
@910 UPD_CODE $001.
;
CALL EXECUTE(
"PROC SQL; UPDATE DB2LIB.TABLE1 SET UPD_CODE =" || UPD_CODE || "WHERE POLICY_NUM = '" || POLICY_NUM || "' ; QUIT;");
;
RUN;
|
I have around 0.5 million records to update... The above code updated the data for around 18,000 records and then abended with the following reason
Code: |
ERROR: PROC SQL statement aborted due to insufficient memory.
|
I have given the following values for the buffer
Is there anyway to avoid this error.. or just increasing the temp. buffer size...?? Could you please tell me...?? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Insufficient memory also certainly has nothing to do with the amount of work space allocated -- insufficient memory messages usually mean SAS ran out of memory (the REGION= parameter on the EXEC JCL statement). Work space is disk space; memory is in-core memory. |
|
Back to top |
|
|
|