Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SAS: CALL EXECUTE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: SAS: CALL EXECUTE
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: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Mon Jan 31, 2011 6:25 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us