Unload Utility With External Format.



IBM's flagship relational database management system

Unload Utility With External Format.

Postby manojlives » Mon Feb 22, 2010 5:44 pm

Hi,
If i am unloading table using DSNTULIB utility , the Output is not user readable format , as it writes few columns as ASCII chars ,
As far as i know there is a FORMAT specification in Platinum FAST unload utility where we can specify FORMAT : EXTERNAl, and it unloads the data in EXTERNAL format , that is User readable.

Can anyone suggest me is there a way to do the same using UNLOAD utility.
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility With External Format.

Postby dick scherrer » Tue Feb 23, 2010 12:53 am

Hello,

as it writes few columns as ASCII chars ,
On the mainframe? Why would an unload create data in ascii on a mainframe? The mainframe is ebcdic based. . .
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 With External Format.

Postby manojlives » Tue Feb 23, 2010 4:11 pm

dick scherrer wrote:Hello,

as it writes few columns as ASCII chars ,
On the mainframe? Why would an unload create data in ascii on a mainframe? The mainframe is ebcdic based. . .


Sorry dick scherrer it was a mistake , the output format of unload util is EBCDIC Format .
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility With External Format.

Postby dick scherrer » Wed Feb 24, 2010 1:30 am

Hello,

Sorry dick scherrer it was a mistake
Not to worry :)

Why does unloaded data need to be readble by some user? UNLOADed data is perfectly readable/usable by programs and utilities. . .

Obviously, i am missing something :?
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 With External Format.

Postby manojlives » Thu Feb 25, 2010 11:25 am

dick scherrer wrote:Hello,

Sorry dick scherrer it was a mistake
Not to worry :)

Why does unloaded data need to be readbale by some user? UNLOADed data is perfectly readable/usable by programs and utilities. . .

Obviously, i am missing something :?


The purpose we need is to identify the changes between 2 different database of same structure and once compare is run the output is not readable by us to identify the exact row in the table that is missing.
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility With External Format.

Postby dick scherrer » Fri Feb 26, 2010 12:48 am

Hello,

Then you may want to generate the "output to compare" using your own sql code rather than the utility.

There may be something you can use here also:
http://publibz.boulder.ibm.com/cgi-bin/ ... j10/2.30.4
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 With External Format.

Postby manojlives » Mon Mar 01, 2010 2:13 pm

dick scherrer wrote:Hello,

Then you may want to generate the "output to compare" using your own sql code rather than the utility.

There may be something you can use here also:
http://publibz.boulder.ibm.com/cgi-bin/ ... j10/2.30.4

Hi Dick,

I am unloading the entire database using, LISTDEF and TEMPLATE Utility , In that case i am not able to specify the column names while unloading.
I am using below syntax in my unload job , then how can i specify column wise for all tables, which is not allowed.
For Eg:

LISTDEF UNLDLIST
INCLUDE TABLESPACE TDB1.TSP*
TEMPLATE UNLDDS DSN &USERID..SMPLUNLD.&TS.
UNIT SYSDA DISP (NEW,CATLG,CATLG) SPACE (2,1) CYL
UNLOAD LIST UNLDLIST
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility With External Format.

Postby dick scherrer » Tue Mar 02, 2010 12:41 am

Hello,

As i mentioned earlier, you might consider writing your own code to do what you want.

IMHO, utilities are great when they can be used "as is". For more specific/complicated requirements, i write my own as i feel i have greater control and flexibility.
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 With External Format.

Postby manojlives » Sat Mar 06, 2010 5:39 pm

dick scherrer wrote:Hello,

As i mentioned earlier, you might consider writing your own code to do what you want.

IMHO, utilities are great when they can be used "as is". For more specific/complicated requirements, i write my own as i feel i have greater control and flexibility.

Thanks Dick , Pls let me know how to write the IMHO utiity or provide me with any documents that might help me write it.
manojlives
 
Posts: 37
Joined: Wed Dec 24, 2008 5:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unload Utility With External Format.

Postby dick scherrer » Sat Mar 06, 2010 9:42 pm

Hello,

Sorry, my bad - i should not have used "slang". IMHO means In My Humble Opinion. . .

The point is that utilities are not always able to do what someone wants. Then one must write their own code to do what is needed. As i mentioned before:
Then you may want to generate the "output to compare" using your own sql code rather than the utility.
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


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post