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: schultheis@tde-online.de
Phone: +49 7245 9287-21

Burkhard Schultheis wrote:[color=blue]
> 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?[/color]

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

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.