Page 1 of 1

Unload utility and Select difference.

PostPosted: Wed Dec 02, 2009 6:26 pm
by manojlives
Hi,
I use below Unload utility to unload a table.
//UNLOAD EXEC PGM=DSNUTILB,PARM='DB2X,xxxxx'
//STEPLIB DD DSN=DB2D.SDSNLOAD,DISP=SHR
//SYSREC DD DSN=BPV255.VVT.UNLOAD.DFxx.yyyyyy,
//UTPRINT DD SYSOUT=*
//SYSIN DD *
UNLOAD DATA FROM TABLE db2x.xxxxx;
/*
If i use below method to unload table,
//UNLD1 EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSREC00 DD DSN=xxxxx.yyyyyy,
//SYSTSIN DD *
DSN SYSTEM(DB2x)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB51) LIB('DB2x.RUNLIB.LOAD') -
PARMS('SQL')
END
//SYSIN DD *
select * from db2x.xxxxx

Both the unloaded dataset have different format.
Is it possible to use UNLOAD utility to get the format of the second method. Pls help me out.

Re: Unload utility and Select difference.

PostPosted: Thu Dec 03, 2009 4:08 am
by dick scherrer
Hello,

Is it possible to use UNLOAD utility to get the format of the second method
Not that i'm aware of. . .

You might consider using the unload and then reformatting the output or writing a bit of code to create the output however you want it.

Re: Unload utility and Select difference.

PostPosted: Thu Dec 03, 2009 11:48 am
by manojlives
Is it possible to use unload utility to get the FORMAT: EXTERNAl, I could use that in platinum fast unload,

Except for the foramt :EBCDIC,ASCII,UNICODE , are there any other formats that we can unload the data.
Is that possible?