Type cast

vinodhraj · Post by **vinodhraj** » Sun Mar 04, 2007 11:17 pm

Hi,

I want convert datatypes inside the transformer.
Any soluton.

Thanks

Vinod

DSguru2B · Post by **DSguru2B** » Sun Mar 04, 2007 11:20 pm

In server jobs just change the sql type of the target stage. The change is implicit, unlike parallel jobs.

kumar_s · Post by **kumar_s** » Sun Mar 04, 2007 11:25 pm

There are 'Conversion' available under 'Functions'. Iconv/Oconv are majorly used.

DSguru2B · Post by **DSguru2B** » Sun Mar 04, 2007 11:29 pm

kumar_s wrote:There are 'Conversion' available under 'Functions'. Iconv/Oconv are majorly used.

ICONV/OCONV for datatype conversions

, you sure Kumar?

kumar_s · Post by **kumar_s** » Sun Mar 04, 2007 11:35 pm

The main function of the Iconv is to convert the external data type into Datastage internal format, and Oconv is to convert the Datastge internals to External format. String to data or vice versa, or Decimal and its vice versa etc, are done using this.

DSguru2B · Post by **DSguru2B** » Sun Mar 04, 2007 11:40 pm

Hmm, interesting. Server is still linient. Even if these functions are not used, the datatypes can be altered by specifying different target datatypes.

kumar_s · Post by **kumar_s** » Sun Mar 04, 2007 11:41 pm

DSguru2B wrote:Hmm, interesting. Server is still linient. Even if these functions are not used, the datatypes can be altered by specifying different target datatypes.

Yes for most of the cases.

chulett · Post by **chulett** » Mon Mar 05, 2007 1:10 am

Or just by using the data. Performing math on it, for instance.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 05, 2007 7:58 am

vinodhraj wrote:Hi,

I want convert datatypes inside the transformer.
Any soluton.

Thanks

Vinod

There ARE no data types inside the Transformer in server jobs.

Can you be more specific as to your requirement?

DSXchange

Type cast

Type cast

Re: Type cast