Oninit cdi / Archive
Talk to an expert →

SERIAL from Informix ODBC??

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET

koerper@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

I'd like to get the value assigned to a serial column when using insert with the Informix ODBC Driver. There is a macro named SQL_GET_SERIAL_VALUE in */incl/cli/infxcli.h. Is anyone familiar with how to use this setting for efficient retrieval of the SERIAL value?? Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to koerper@my-deja.com
Chetan Anand — — source: Informix-list mailing list archive (1991-1998)

Try SELECT DBINFO( 'sqlca.sqlerrd2' ) FROM systables WHERE tabid = 1; immeditely after INSERT. Above SQL will return last serial value inserted. Rgds koerper@my-deja.com wrote: > I'd like to get the value assigned to a serial > column when using insert with the Informix ODBC > Driver. There is a macro named > > SQL_GET_SERIAL_VALUE > > in */incl/cli/infxcli.h. Is anyone familiar with > how to use this setting for efficient retrieval of > the SERIAL value?? > > Sent via Deja.com http://www.deja.com/ > Before you buy.