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
Problem with ODBC stage
Moderators: chulett, rschirm, roy
There is an active thread with the same topic going on right now.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Problem with ODBC stage
There are couple of bug's that IBM fixed on ODBC and DRS stage.
contact tech support for them
-pratap
contact tech support for them
-pratap
bkumar103 wrote: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
Thanks & Regards
Pratap Bhimireddy
Pratap Bhimireddy