Data format issue

[rajudx]

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

[suja.somu]

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

[rajudx]

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.

[ray.wurlod]

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.