| View previous topic :: View next topic |
| Author |
Message |
murali
Beginner
Joined: 21 Apr 2004
Posts: 12
Topics: 9
|
 Posted: Mon Jun 21, 2004 4:35 am Post subject: Spufi JCL |
 |
|
| The spufi query takes a long time and my session is locked and i cannot do any thing. Can I run spufi in JCl ? please send me the spufi jcl |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12368
Topics: 75
Location: San Jose
|
| Posted: Mon Jun 21, 2004 5:09 am Post subject: |
|
|
Murali,
Technically speaking you can run spufi in batch. I used to have a sample, but I have to dig for it and it was a big task to make it run.
You can use DSNTEP2 which is a sample dynamic SQL program in the PL/I language. With this program, you can execute any SQL statement that can be executed dynamically. You can use the source version of DSNTEP2 and modify it to meet your needs, or, if you do not have a PL/I compiler at your installation, you can use the object code version of DSNTEP2.
or you can even use DSNTIAUL which is a sample unload program. This program, which is written in assembler language, unloads some or all rows from up to 100 DB2 tables. With DSNTIAUL, you can unload data of any DB2 built-in data type or distinct type. You can unload up to 32KB of data from a LOB column. DSNTIAUL unloads the rows in a form that is compatible with the LOAD utility and generates utility control statements for LOAD. DSNTIAUL also lets you execute any SQL non-SELECT statement that can be executed dynamically.
Check this link for running DSNTIAUL, DSNTIAD, and DSNTEP2
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3?DT=20010710165542
Hope this helps...
Cheers
Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
sriramla
Beginner
Joined: 22 Feb 2003
Posts: 74
Topics: 1
|
| Posted: Mon Jun 21, 2004 2:17 pm Post subject: |
|
|
You can try this:
| Code: | //Job Card
//BATCHSQL EXEC PGM=IKJEFT01
//STEPLIB DD DSN=HLQ.DB2.SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(XXXX)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) -
LIB('HLQ.DB2.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
SELECT * FROM table name;
|
You need to replace XXXX with your sub system ID. Also change the DB2 Library names based on your shop installation standards. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
