Sounds like a driver issue. Workaround: use the SQL NVL function, all your nulls should become something else (how about "666"? the number of the beast? hehehehe) you can handle that value easily.
Greg
-----Original Message-----
From: Mohan P Gujral [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 8:23 PM
To: jdjlist
Subject: [jdjlist] Data truncated
Scenario:
I am trying to read a table column(long varchar-31600) which can have a null
character in it.
Environment :
DB2 Client on Websphere application server on sun solaris accessing the above
table on mainframe.
Problem:
The data gets truncated from point where it encounters null character.
Any known soln or patches/fixes? The same works when you access the table using
DB2 Client on Windows 2000 instead of Sun Solaris.
Thanks,
Mohanpreet
---
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
