vani
Beginner
Joined: 28 May 2003
Posts: 51
Topics: 30
|
 Posted: Tue Nov 11, 2003 10:58 pm Post subject: DB2 temporary tables |
 |
|
I have a batch program which will execute 6 programs one after the other. Now in the first program if I create temporary tables, can they be used in subsequent programs for execution.
JCL looks like this
| Code: |
Step1 EXEC SAS,WORK='12000,500'
//*AS.SASLIST DD SYSOUT=C
//SAS.SASLIST DD SYSOUT=*
//SAS.SASLOG DD SYSOUT=*
//CONFIG DD DSN=T02154A.SAS.CONFIG(DB0T),DISP=SHR
//SASEXEC DD DSN=T02154A.SAS.AUTOEXEC(TS$$004),DISP=SHR
//WORKPSIO DD DSN=T02154A.T2ELAS.WORK,DISP=OLD
//SYSIN DD DSN=T02154A.ELAS.PARM(AWDBUP21),DISP=SHR
//*
//*** 3. TEIL: UPDATES
//*
//Step2 EXEC SAS,WORK='12000,500'
//*AS.SASLIST DD SYSOUT=C
//SAS.SASLIST DD SYSOUT=*
//SAS.SASLOG DD SYSOUT=*
//CONFIG DD DSN=T02154A.SAS.CONFIG(DB0T),DISP=SHR
//S ASEXEC DD DSN=T02154A.SAS.AUTOEXEC(TS$$004),DISP=SHR
//WORKPSIO DD DSN=T02154A.T2ELAS.WORK,DISP=OLD
//SYSIN DD DSN=T02154A.ELAS.PARM(AWDBUP31),DISP=SHR
//*
//*** 4. TEIL: UPDATES
//*
//Step3 EXEC SAS,WORK='12000,500'
//*AS.SASLIST DD SYSOUT=C
//SAS.SASLIST DD SYSOUT=*
//SAS.SASLOG DD SYSOUT=*
//CONFIG DD DSN=T02154A.SAS.CONFIG(DB0T),DISP=SHR
//SASEXEC DD DSN=T02154A.SAS.AUTOEXEC(TS$$004),DISP=SHR
//WORKPSIO DD DSN=T02154A.T2ELAS.WORK,DISP=OLD
//SYSIN DD DSN=T02154A.ELAS.PARM(AWDBUP41),DISP=SHR
//*
|
Or whether can we create temporary tables and retain them in buffers after execution of the program??
Please provide inputs on this |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
