IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SAS: CALL EXECUTE


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rajesh1183

New User


Joined: 07 Jan 2008
Posts: 98
Location: Hyderabad

PostPosted: Mon Jan 31, 2011 5:23 pm
Reply with quote

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
Code:

WORK='2000,2000'


Is there anyway to avoid this error.. or just increasing the temp. buffer size...?? Could you please tell me...??
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Mon Jan 31, 2011 6:25 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Execute secondary panel of sdsf with ... CLIST & REXX 1
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Error while running web tool kit REXX... CLIST & REXX 5
This topic is locked: you cannot edit posts or make replies. How To Write, Compile and Execute Cob... COBOL Programming 5
No new posts Call program, directly from panel CLIST & REXX 9
Search our Forums:

Back to Top