Type cast
Posted: Sun Mar 04, 2007 11:17 pm
Hi,
I want convert datatypes inside the transformer.
Any soluton.
Thanks
Vinod
I want convert datatypes inside the transformer.
Any soluton.
Thanks
Vinod
Page 1 of 1
Posted: 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.
Posted: Sun Mar 04, 2007 11:25 pm
There are 'Conversion' available under 'Functions'. Iconv/Oconv are majorly used.
Posted: Sun Mar 04, 2007 11:29 pm
ICONV/OCONV for datatype conversionskumar_s wrote:There are 'Conversion' available under 'Functions'. Iconv/Oconv are majorly used.
, you sure Kumar?Posted: 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.
Posted: 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.
Posted: Sun Mar 04, 2007 11:41 pm
Yes for most of the cases.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.
Posted: Mon Mar 05, 2007 1:10 am
Or just by using the data. Performing math on it, for instance.
Re: Type cast
Posted: Mon Mar 05, 2007 7:58 am
There ARE no data types inside the Transformer in server jobs.vinodhraj wrote:Hi,
I want convert datatypes inside the transformer.
Any soluton.
Thanks
Vinod
Can you be more specific as to your requirement?