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
 
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 Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm

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