How to change the DSNTIAUL-Syspunch load statements?

Raja Durai · New User Joined: 06 Jul 2008 Posts: 6 Location: chennai

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

sushanth bobby · Posted: Wed Sep 29, 2010 10:09 pm

Hi Raja,

Welcome to IBMMAINFRAME!.

Anuj Dhawan · Posted: Thu Sep 30, 2010 4:32 pm

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.

Raja Durai · New User Joined: 06 Jul 2008 Posts: 6 Location: chennai

Thank you ,Sushanth & Anuj. I will work it out and let you know the results.

Anuj Dhawan · Posted: Mon Oct 04, 2010 7:47 pm

Good Luck.