Re: How do I get value of serial column of record in java

In article <6k1i08$21f$1@news.xmission.com>, candym@olcinc.com says... >I need to get the value of a serial column just inserted into a table = >when programming >in java using JDBC. The informix engine could be SE or ODS. I'd = >appreciate anyone's >help. Thanks in advance! Informix 7 has a DBINFO call that you can use; select DBINFO('sqlca.sqlerrd1') from any_table will return the value of the last inserted serial number. If you're using something prior to Informix 7, or something that tries to parse the SQL before it sends it to the engine, you might be out of luck; it would have to be some JDBC-specific enhancement, I would guess. P.S. - Please don't post in HTML. A lot (most?) of people don't have HTML-aware news readers, and many will just skip an HTML message without bothering to try to read it. -- William Harris william@carsinfo.com Check out the NAGS spam filter. http://www.nags.org