Unload using DSNUTILB



IBM's flagship relational database management system

Unload using DSNUTILB

Postby akanchu » Wed Jan 13, 2010 11:04 am

Hi,

We had a utility/tool - X that we used to pull data from the DB2 table.

Due to some cost issues, we are about to stop using that tool X.

We have to start using DSNUTILB to unload the data from the same DB2 tables.

This data pulled from util X/DSNUTILB is being passed to a different system for storage purpose and reporting purpose.

We are now facing an issue in the difference between the format of data the tool X unloads and
the format of data DSNUTILB unloads data.

eg. I have a VARCHAR field say line-1.
using tool X, we used to get it in like :

1799 ARBYDALE LN..........................................
FFFF4CDCECCDC4DD000000000000000000000000000000000000000000
1799019284135035000000000000000000000000000000000000000000
 ---------------------------------------------------------
1234 HILTON WHITEMALL RD..................................
FFFF4CCDEDD4ECCECDCDD4DC0000000000000000000000000000000000
1234089336506893541330940000000000000000000000000000000000
 ---------------------------------------------------------
2025 S DUMPBELL AVE APT 317...............................
FFFF4E4CEDDCCDD4CEC4CDE4FFF0000000000000000000000000000000
2025020444725330155017303170000000000000000000000000000000



but with DSNUTILB, we are getting it in this format.


1799 ARBYDALE LN                                         
FFFF4CDCECCDC4DD444444444444444444444444444444444444444444
1799019284135035000000000000000000000000000000000000000000
----------------------------------------------------------
1234 HILTON WHITEMALL RD                                 
FFFF4CCDEDD4ECCECDCDD4DC4444444444444444444444444444444444
1234089336506893541330940000000000000000000000000000000000
----------------------------------------------------------
2025 S DUMPBELL AVE APT 317                               
FFFF4E4CEDDCCDD4CEC4CDE4FFF4444444444444444444444444444444
2025020444725330155017303170000000000000000000000000000000


With this way, the downstream is not able to decide where the data actually ended.

Is there an option or parameter that can be set in DSNUTILB to make the data look like the above tool X.

We cannot change the downstream systems that accept this data and straight forward conversion from space to low-values will not help as there are spaces in between the contents/text.

Any suggesions ?
akanchu
 
Posts: 36
Joined: Fri Jan 23, 2009 3:11 am
Has thanked: 0 time
Been thanked: 0 time

Re: Unload using DSNUTILB

 

Re: Unload using DSNUTILB

Postby dick scherrer » Thu Jan 14, 2010 1:02 am

Hello,

Before all is done, it may not be cheaper to replace X. . .

Once the data is extracted, you could implement code to replace the trailing spaces with x'00's.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Unload using DSNUTILB

Postby akanchu » Thu Jan 14, 2010 11:50 am

Thanks dick.

Well decision has been made and we have to get rid of tool X. :(

I am working on that option too. But do not have a solution as of now to convert the trailing spaces to low values.
Especially with data and different length file issues.

thanks.
akanchu
 
Posts: 36
Joined: Fri Jan 23, 2009 3:11 am
Has thanked: 0 time
Been thanked: 0 time

Re: Unload using DSNUTILB

Postby dick scherrer » Fri Jan 15, 2010 12:18 am

Hello,

Suggest you use COBOL.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post