integer to string

dsproj2003 · Post by **dsproj2003** » Mon Aug 04, 2003 4:29 pm

What is the simplest way of converting smallint/integer to string?

Regards,
Nitin

ray.wurlod · Post by **ray.wurlod** » Mon Aug 04, 2003 4:52 pm

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

kcbland · Post by **kcbland** » Mon Aug 04, 2003 4:53 pm

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

Teej · Post by **Teej** » Fri Aug 08, 2003 1:38 pm

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.