DSXchange

Hi,

In one of the datastage job generating data from mainframe DB2 table and in sequential output file all decimal column values populating dot "." at end of the value.

e.g. 5937510.|987678.|
0902339.|349012.|
4567891.|1267898.|

Is there any option in sequential file stage which can remove dot "." from the actual value.

Output should be like below.

5937510|987678|
0902339|349012|
4567891|1267898|

Please help me on this issue

Can you specify the datatype and length of this column in DB2 and also in Sequential file that you created?

Data type defined as decimal 19 and metadata passing in job through dynamically using RCP future.
No columns names mentioned in sequential file stage under columns tab.

Data type decimal will always have a decimal placeholder, even if scale is 0. To avoid, change the data type to integer or string. In the latter case use Convert() function to eliminate the "." character.