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 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 Fail to change physical VSAM filename... jacobdng CICS 5 Fri Jan 20, 2017 12:36 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am


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