Re: Serial field in Java

Posted in 1998

Edwin Babadaglian — Thu, 02 Apr 1998 03:01:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Andrew Gillespie wrote: > Is there any way to retrieve the last serial field number inserted > into an Informix table when using Java and JDBC? You can normally > look in SQLCA.SQLERRD[2] but this wont work with Java. Check out the DBINFO function. After inserting a row, execute the following to get the serial value: <Statement obj>.executeQuery( "SELECT DBINFO('sqlca.sqlerrd1') FROM <table>" ) Edwin Babadaglian edwinb@panix.com