How to remove leading zeros in DataStage

datastage
Ley Gail picture Ley Gail · May 7, 2015 · Viewed 16.9k times · Source

I am trying to remove the leading zeros in the decimal field in a sequential file stage. what is the solution for this problem ?

Answer

Barak Kedem picture Barak Kedem · May 7, 2015

The easy way is with : Trim(DecimalTostring(In.Col),'0','L') 

Related questions

SQLState 02000 No row was found for FETCH, UPDATE, or DELETE

I'm running jobs through Datastage with the DELETE then INSERT connector. I'm having several jobs failing for this error: DB2_Connector: DB2 reported: SQLSTATE = 02000 Native Error Code = 100, Msg = IBM[CLIDriver][DB2/NT64] SQL01000W No row was found for FETCH, …

Read More
Dumping dataset (.ds) file contents to a text file

At work we use DataStage which uses dataset (.ds) files. I can view the contents of the file from without our UNIX environment by using: orchadmin dump -name <dataset name> This only dumps the contents of the file …

Read More
How to transform a string into timestamp in DataStage?

I read data from a csv file,and I get a string like "2010-7-3", I can't transform this data into timestamp,because it not like "2010-07-03" What should I do?Is there a stage could handle this?

Read More