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 change the DSNTIAUL-Syspunch load statements?

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

New User


Joined: 06 Jul 2008
Posts: 6
Location: chennai

PostPosted: Wed Sep 29, 2010 11:15 am    Post subject: How to change the DSNTIAUL-Syspunch load statements?
Reply with quote

Hi,

When we run the DSNTIAUL unload utility We get the SYSPUNCH dataset with
LOAD DATA LOG NO INDDN SYSREC00 INTO TABLE
Userid.Department

But I need the Card in the below format.

LOAD DATA LOG NO REPLACE REUSE ENFORCE NO NOCOPYPEND
INDDN SYSREC00 INTO TABLE

Userid.Department


Now I am doing this with a Sort utility.
And My question is is there anyway to get the desired syspunch statements With DB2 utility itself.

Thanks,
Raja
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Sep 29, 2010 10:09 pm    Post subject:
Reply with quote

Hi Raja,

Welcome to IBMMAINFRAME!.

Quote:
And My question is is there anyway to get the desired syspunch statements With DB2 utility itself.

Nope. External mechainsm is needed.

Sushanth
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Sep 30, 2010 4:32 pm    Post subject:
Reply with quote

This is what IBM has to say on this, I've not worked much on this, though:

Syntax and options of the LOAD control statement
The LOAD utility control statement, with its multiple options, defines the function that the utility job performs.

You can create a control statement with the ISPF/PDF edit function. After creating it, save it in a sequential or partitioned data set. When you create the JCL for running the job, use the SYSIN DD statement to specify the name of the data set that contains the utility control statement.
Back to top
View user's profile Send private message
Raja Durai

New User


Joined: 06 Jul 2008
Posts: 6
Location: chennai

PostPosted: Fri Oct 01, 2010 11:07 pm    Post subject:
Reply with quote

Thank you ,Sushanth & Anuj. I will work it out and let you know the results.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Oct 04, 2010 7:47 pm    Post subject:
Reply with quote

Good Luck.
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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts PLI %IF statements Pedro PL/I & Assembler 1 Tue Sep 19, 2017 12:06 am
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm

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