Page 1 of 1

BMC Unload - Unload Table with data partition

PostPosted: Tue Oct 18, 2011 1:06 pm
by nikesh_rai
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

Re: BMC Unload - Unload Table with data partition

PostPosted: Sat Nov 24, 2012 12:11 am
by nikesh_rai
Hi,

as the problem mentioned above, Unloading data for different partition of table in different data set in not possible with Direct No option