RE: Retrieving SERIAL identifiers in a concurrent environment

Bill Yes it is always correct! It will contain the serial of that particular insert until the next sql command is executed by that session. Keith -----Original Message----- From: Bill [mailto:laidback@finsco.com] Sent: Monday, January 02, 2006 8:49 PM To: informix-list Subject: Re: Retrieving SERIAL identifiers in a concurrent environment My concern is "is it always correct"? Does the serial id come from that user's session in some buffer, or what? The manual says to get sqlerrd1 "immediately" after the insert. Hopefully that means "before another operation on the database by this program". Is that your understanding? >> SELECT DBINFO('sqlca.sqlerrd1') >> FROM systables >> WHERE tabname = 'systables' > _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************