Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8165
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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us