Page 1 of 1

Conversion

Posted: Wed Nov 04, 2009 1:59 pm
by pandujoy
How to convert an Interger value to Varchar and Varchar to Integer.....

Please help me...I dont know how to convert this value.

Posted: Wed Nov 04, 2009 2:42 pm
by ray.wurlod
Read the Parallel Job Developer's Guide about implicit and explicit data type conversions (you can search within the PDF).

In short you can convert from any numeric to string implicitly but the reverse operation will require a conversion function. The name of the function will depend on whether you are effecting the conversion within a Modify stage or a Transformer stage.