Re: Returning serial value from SP, not using SQLCA

Posted in 1996

elderbox@teleport.com — 30 Jul 1996 02:23:07 -0400 — source: Informix-list mailing list archive (1991-1998)

> > Does anyone know if there is a way to return, from a stored procedure which > inserts a row with a serial column, the VALUE of the serial number, without > doing a second select? sqlca.sqlerrd[2] should contain the value, but the sqlca Actually the sqlca structure is not unknown to SP. At least it is not unknown to my version, Online version 7.1. I get the serial number back by using this routine. LET sernum = dbinfo("sqlca.sqlerrd1~); Admittedly I had to pay good money for the class on Stored procedures to learn this.