Hello All informix Users

I want to retrive data from Informix(Unix) & add into Oracle NT(Windows) for ODBC,Oledb sql syntax checking i made some form in VB6

but i write a query check the Sysntax it not run but some syntax are run properly eg. select * from systables but this advance query not run

SELECT a.tabname, b.colno, b.colname, b.coltype, b.collength
FROM systables a, syscolumns b
WHERE a.tabid = b.tabid
ORDER BY b.colno;

in informix is run proper i check all odbc string (CSDK.2.81.TC2 )

give me answer pls

From

Sudhir

Hi Sudhir,

I think that depending on you Ibm-Informix version, the size of the name the tables was incremented of 18 to 128 characters.

Please test running:

SELECT substr(a.tabname,1,22), b.colno,
substr(b.colname,1,22), b.coltype, b.collength
FROM systables a, syscolumns b
WHERE a.tabid = b.tabid
ORDER BY b.colno

Gustavo.