IBM Mainframe Forum

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.

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.

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?