BMC Unload - Unload Table with data partition



All other tools like QACenter, Strobe, Endevor, Telon, APAS, Scheduler, Auditor, DATA-XPERT, CoolGen, Intertest, AdvantageGen, COBTEST etc.

BMC Unload - Unload Table with data partition

Postby nikesh_rai » Tue Oct 18, 2011 1:06 pm

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
Thanks
Nikesh Rai
nikesh_rai
 
Posts: 205
Joined: Tue Oct 18, 2011 1:27 am
Has thanked: 17 times
Been thanked: 0 time

Re: BMC Unload - Unload Table with data partition

Postby nikesh_rai » Sat Nov 24, 2012 12:11 am

Hi,

as the problem mentioned above, Unloading data for different partition of table in different data set in not possible with Direct No option
Thanks
Nikesh Rai
nikesh_rai
 
Posts: 205
Joined: Tue Oct 18, 2011 1:27 am
Has thanked: 17 times
Been thanked: 0 time


Return to All Other Tools

 


  • Related topics
    Replies
    Views
    Last post