Unload utility and Select difference.



IBM's flagship relational database management system

Unload utility and Select difference.

Postby manojlives » Wed Dec 02, 2009 6:26 pm

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.
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload utility and Select difference.

Postby dick scherrer » Thu Dec 03, 2009 4:08 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Unload utility and Select difference.

Postby manojlives » Thu Dec 03, 2009 11:48 am

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?
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post