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
 

 

How to run SPUFI in batch

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
abc2000

New User


Joined: 15 Dec 2005
Posts: 5

PostPosted: Thu Apr 13, 2006 7:35 am    Post subject: How to run SPUFI in batch
Reply with quote

How to run SPUFI in batch


I have seen
"How to run SPUFI in batch"

http://groups.google.com/group/bit.listserv.db2-l/browse_thread/thread/5ea4629d20bee493/5b9806f06c07f6ae%235b9806f06c07f6ae

Who had did it? Can you give some detail?
Back to top
View user's profile Send private message

radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Thu Apr 13, 2006 10:08 am    Post subject:
Reply with quote

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
View user's profile Send private message
abc2000

New User


Joined: 15 Dec 2005
Posts: 5

PostPosted: Fri Apr 14, 2006 5:39 pm    Post subject: Re: setup SPUFI in batch
Reply with quote

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
View user's profile Send private message
Shaket999

New User


Joined: 08 Jan 2007
Posts: 1
Location: delhi

PostPosted: Thu Feb 01, 2007 5:33 pm    Post subject: run spufi in batch not DSNTEP2
Reply with quote

The example given above uses DSNTEP2

is it possible to run SPUFI in batch ( having ROLLBACK )


regrds,
shaket
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Thu Feb 01, 2007 6:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm


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