IBM Mainframe Forum

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 :



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



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 ?

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.

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.

Hello,

Suggest you use COBOL.