IBM Mainframe Forum

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.

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. . .

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 .

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

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.

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

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

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.

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.

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.