I have been searching the archives and have not found anything useful on
CLOB errors in SQL transform so I am hoping my question is not too
redundant....
IBM DB2 driver is complaining:
DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63
and not returning clob values when clob fields are included in the
select. Query works fine when CLOB fields are not included in SELECT
statement.
My sql transform includes:
<!-- <map:parameter name="clob-encoding" value="UTF-8"/> -->
<map:parameter name="clob-encoding" value="ISO-8859-1"/>
The db2 server encoding is ISO-8859-1. I have tried both encodings with
the same error.
Any help would be greatly appreciated. -Alec
--
Alec Brecher
AtomD / E Research Resources
office: 802 253-8908
http://www.atomd.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
