VARCHAR to BigInt

shave · Post by **shave** » Thu Jun 26, 2008 11:31 pm

Hello

I am reading a csv file into a sequential file stage and loading it into a ODBC stage using a transformer. All datatypes in Sequential File are converted to varchar.. where as in my ODBC stage I have Bigint, char,date datatypes.

Please do let me know what functions I need to use to convert varchar to BigInt and How?

DS_FocusGroup · Post by **DS_FocusGroup** » Fri Jun 27, 2008 12:02 am

How can you ever do this

"loading it into a ODBC stage using a transformer" ??

i assume it would be some database. which one ?

shave · Post by **shave** » Fri Jun 27, 2008 12:12 am

My target is DB2 database. But I am trying to load it using ODBC Stage.. Please let me know how can I do it using Transformer or Modify Stage

sreddy · Post by **sreddy** » Fri Jun 27, 2008 12:51 am

Shave

After reading i understand you can view your data present Varchar data type. All your source CSV data is in Integer or number right.

Try to cover all your source column data types in to as per the Target types and try to view the data.

shave wrote:My target is DB2 database. But I am trying to load it using ODBC Stage.. Please let me know how can I do it using Transformer or Modify Stage

ArndW · Post by **ArndW** » Fri Jun 27, 2008 5:51 am

Many conversions from VarChar() to other types, particularly numeric ones, can be done implicitly. You will need to use the StringToDate() function for the date conversion if your job uses transform stages, otherwise the modify stage does conversions as well, but uses other function names and a different syntax.