Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: CSDK.2.81.TC2 not support advance query

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •