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