Hi
I have craeted Unload job which will use BMC Unload to unload data from table having 8 data partition in 8 diffrent file. Problem is that when unloading job, i want to use Direct No option, since i need to convert date in julian format from current format. But with direct no, data will be unloaded in one file for all data partition.
If i will use Direct Yes, data will be unloaded in all 8 files as per data partition, but in this case Date conversion is not possible, since for this we need Direct No
This is the unload card i am using
UNLOAD
SHRLEVEL CHANGE
FORMAT EXTERNAL
FIXEDVARCHAR YES
CNTLCARDS DB2
CNTLDDN CNTL
UNLOADDN SYSRE
**DIRECT NO\YES
Can any one suggest on this