Problem with ODBC stage

[bkumar103]

Hi,
I am using ODBC stage to read the data from SQL Server to put into a sequential file. I am just using select * from <tablename> as the query in the ODBC stage. But strange, Data from the character column type and date column type are getting truncated. For other data type its fine.

Any light on this issue? And also any solution for this.

Thanks in advance,
Birendra

[ArndW]

There is an active thread with the same topic going on right now.

[pathmaker]

There are couple of bug's that IBM fixed on ODBC and DRS stage.
contact tech support for them

-pratap

Hi,
I am using ODBC stage to read the data from SQL Server to put into a sequential file. I am just using select * from <tablename> as the query in the ODBC stage. But strange, Data from the character column type and date column type are getting truncated. For other data type its fine.

Any light on this issue? And also any solution for this.

Thanks in advance,
Birendra