DSXchange

I am fetching rows from the database and writing it to a dataset with copy stage in the middle. the SQL select gives the following result

in the dataset when i view the data its shown like: zeros are being added as a prefix to Column2 which is Decimal 15,2 i dont think its the problem with the APT_PAD_CHAR variable. Any other things i need to have a look into ?

Thanks.

DS_FocusGroup wrote:I am fetching rows from the database and writing it to a dataset with copy stage in the middle. the SQL select gives the following result

Code: Select all

 Column1                                   Column2
 997000045147278	                223319.43

in the dataset when i view the data its shown like:

Code: Select all

 Column1                                   Column2
 997000045147278	                0000000223319.43

zeros are being added as a prefix to Column2 which is Decimal 15,2 i dont think its the problem with the APT_PAD_CHAR variable. Any other things i need to have a look into ?

Thanks.

Which version of Data Stage are you using. That is DataStage PX bug in the version 7.5 series.

That's not a bug. Data in a dataset is stored in an internal format. The PX engine displays decimal data to the outside world (e.g. view data) in the format that you see. If you want specially formatted output, you need to convert from decimal to string... or pass it to a reporting tool for a formatted display.

Mike

In other words, it's neither a bug nor a problem, just an artifact of how View Data presents the data to you.