hi all
i am reading a column in the flat file as string i.e varchar.while loading it into the oracle table the column defination in the table is number.so i am unable to load the column.i am using ODBC stage for this purpose.can anybody suggest me how can i convert varchar to number to load into table properly.is there any function for this purpose...
varchar to number conversion
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In a server job, simply pass it through a Transformer stage in which the input link carries the column as a VarChar and the output link carries the column as the appropriate numeric type.
Ideally, constrain the output link with a test that the value is actually numeric. The Num() function is ideal for this purpose.
Ideally, constrain the output link with a test that the value is actually numeric. The Num() function is ideal for this purpose.
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.