Data type not supported

abhilashnair · Post by **abhilashnair** » Tue Feb 22, 2011 5:18 am

I am facing problem with DB2 data type Long Varchar. The column is defined as Long Varchar in DB2. The max length of the contents inside this field is 16000. I fired a query to make sure of this. I am using ODBC Enterprise stage and trying to read this column data in datastage. I have imported meta data using ODBC table Definition. It is taking it as LongVarChar with Length of 32800 at the time of import. But when I try to view data it gives an error "Data type not Supported"

DataStage V8.1, DB2 v9.5

Pls advise

chulett · Post by **chulett** » Tue Feb 22, 2011 7:52 am

Ok, view data may not work but does the job run?

abhilashnair · Post by **abhilashnair** » Wed Feb 23, 2011 3:19 am

The job fails with error " Data type not supported"

abhilashnair · Post by **abhilashnair** » Thu Feb 24, 2011 1:35 am

Resolved. Query used inside ODBC.

SELECT CAST(COLNAME AS VARCHAR(4000) AS COLNAME FROM TABLENAME

Define Metadata as VARCHAR. Length 4000

chulett · Post by **chulett** » Thu Feb 24, 2011 8:11 am

I'm curious how that solves your problem when your max data length is four times the size of the CAST output? You don't care if it gets truncated?