By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

SQL0351 when acccessing V7 from V8 client

P: n/a
We tried to select column text from syscat.views from a V7 database with
a V8 client. We got

SQL0351N An unsupported SQLTYPE was encountered in position "1" of the
output
SQLDA (select list). SQLSTATE=56084

In V7, text is a CLOB of size 64k, in V8 it is a CLOB of size 2M.

Bug or feature?

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49 7245 9287-21
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
Burkhard Schultheis wrote:
We tried to select column text from syscat.views from a V7 database with
a V8 client. We got

SQL0351N An unsupported SQLTYPE was encountered in position "1" of the
output
SQLDA (select list). SQLSTATE=56084

In V7, text is a CLOB of size 64k, in V8 it is a CLOB of size 2M.

Bug or feature?


I believe this is a documented incompatibility (there are CLOB issues
with V8 clients talking to V7 servers).

Nov 12 '05 #2

P: n/a
Just don't try it the other way around. V8 with the V7 client, crashes
the server (not the connection, but the server, DB comes up in an
inconsistant state) in certain cases (i found 4) via ODBC.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.