Hallo,

i need some help from a Informix "Specialist" ;-)

i had to wite a litte programm in MS-Visual C# 2010 the should check
if a default value ist set for a column on an informix database
server.

The connection to the database server is using the original ibm odbc
driver.

Is there an existing funktion in the odbc driber or informix server
that can i use ?

Thank you for your help and hints ;-)

create table tessie ( hendrik char(20) default 'haverkamp');

select tabname, colname , c.*
from systables a , syscolumns b ,
sysdefaults c
where a.tabname ='tessie' and b.colname ='hendrik' and
c.tabid = a.tabid and a.tabid = b.tabid and c.colno = b.colno


Superboer.



On 16 feb, 10:54, Burnie <thedarksid... (AT) gmail (DOT) com> wrote: