View previous topic :: View next topic
|
Author |
Message |
abc2000
New User
Joined: 15 Dec 2005 Posts: 5
|
|
Back to top |
|
|
radhakrishnan82
Active User
Joined: 31 Mar 2005 Posts: 435 Location: chennai, India
|
|
|
|
Code: |
//RUNSPUF EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP1) PARMS('/ALIGN(LHS) MIXED') -
LIB('DSN710.RUNLIB.LOAD')
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
SELECT * FROM A2TTRD.C345TY; |
Hope this helps. |
|
Back to top |
|
|
abc2000
New User
Joined: 15 Dec 2005 Posts: 5
|
|
|
|
difference beetween DB2 SPUFI vs DSNTEP2
1. if error DB2 SPUFI can rollback, but DSNTEP2 can not rollback,this
would cause data integrity problem, it is very important
2. DSNTEP2 output line cannot exceed 133bytes,SPUFI can produce fromatted output, a line up to 32767bytes |
|
Back to top |
|
|
Shaket999
New User
Joined: 08 Jan 2007 Posts: 1 Location: delhi
|
|
|
|
The example given above uses DSNTEP2
is it possible to run SPUFI in batch ( having ROLLBACK )
regrds,
shaket |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
SPUFI was meant to be used as an interactive utility. With tedious work (Allocating files, filling ISPF variables, finding the executables etc.) it might be possible to invoke it in batch, but I don't think it worth the effort.
You can write your own REXX (to be run in foregroung), using DSNREXX interface.
O. |
|
Back to top |
|
|
|