check column fo a default value
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...@gmail.com> wrote:
> 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 ;-)