Page 1 of 1
integer to string
Posted: Mon Aug 04, 2003 4:29 pm
by dsproj2003
What is the simplest way of converting smallint/integer to string?
Regards,
Nitin
Posted: Mon Aug 04, 2003 4:52 pm
by ray.wurlod
In a Transformer stage, do nothing!
On the input link declare its data type as SmallInt/Integer.
On the output link declare its data type as Char/VarChar.
This works because the DataStage Engine is flexible about data types internally.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Posted: Mon Aug 04, 2003 4:53 pm
by kcbland
There is no conversion required by DataStage Server. If the source column has metadata as smallint and the target column has metdata of string, simply map the column over.
Kenneth Bland
Posted: Fri Aug 08, 2003 1:38 pm
by Teej
quote:Originally posted by kcbland
[br]There is no conversion required by DataStage Server. If the source column has metadata as smallint and the target column has metdata of string, simply map the column over.
The same is true for DataStage PX.
-T.J.
* * *
... now if this can make breakfast, my life is complete.