How to convert an Interger value to Varchar and Varchar to Integer.....
Please help me...I dont know how to convert this value.
Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.