MVSFORUMS.com

haritha_e · Beginner Joined: 30 Jan 2007 Posts: 14 Topics: 8

Hi All,

We normally unload the partitions for a particular table using the following statements. Using this we can unload all the columns, but can anyone let me know whether we can unload only specific columns using the below approach(not sql unload using DSNTIAUL).

LISTDEF UNLDLIST
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(1)
INCLUDE TABLESPACE TDB1.TSP1 PARTLEVEL(3)
TEMPLATE UNLDDS DSN &USERID..SMPLUNLD.&TS..P&PART.
UNIT SYSDA DISP (NEW,CATLG,CATLG) SPACE (2,1) CYL
UNLOAD LIST UNLDLIST -- LIST name
UNLDDN UNLDDS -- TEMPLATE name

Thanks
Haritha

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Haritha,

You can acheive this using DSNTIAUL utility.

Check the below links.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUG0F6/CCONTENTS?DT=20000421183700

haritha_e · Beginner Joined: 30 Jan 2007 Posts: 14 Topics: 8

Hi Phani,

I wanted to use the Template approach not the one you have mentioned. We have to unload the partitions using the template command.

Thanks
Haritha

CraigG · Posted: Wed Dec 05, 2007 10:43 am Post subject:

Just add the column list to the "UNLOAD LIST UNLDLIST " command.

haritha_e · Beginner Joined: 30 Jan 2007 Posts: 14 Topics: 8

craig,

thanks for the reply. can you provide me with an example?

CraigG · Posted: Wed Dec 05, 2007 11:24 am Post subject: