Re: SQL and serial columns

Posted in 1998

Thomas J. Girsch — Thu, 1 Oct 1998 14:50:40 -0400 — source: Informix-list mailing list archive (1991-1998)

Yup. SELECT DBINFO("sqlca.sqlerrd2") will do the trick. Surfer wrote in message ... > >Using SQL (6.05) (not ESQL or 4GL) is there anyway other than > > select max( mycol ) from mytab > >to find the value of a serial number just created by > > insert into mytab values( 0 )