Re: SPL Question

Posted in 2001

Sue_Davidson@exe.com.au — Thu, 8 Feb 2001 10:28:29 +1100 — source: Informix-list mailing list archive (1991-1998)

LET number = DBINFO ('sqlca.sqlerrd1'); Take a look at the FAQ site: http://www.smooth1.demon.co.uk/informix.htm http://www.iiug.org/resources/index.html provides a link to this site and several other Informix sites. "ROBERT B VORBROKER" <ROBVORBROKER@prodigy.net> on 08/02/2001 08:11:13 Please respond to "ROBERT B VORBROKER" <ROBVORBROKER@prodigy.net> To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) Subject: SPL Question OK I'm asking this for a member of our User Group and don't have the appropriate Manual handy... IN Stored Procedure I want to insert a record with a SERIAL column and somehow have the value of the SERIAL field returned to the calling program. In 4GL the value of the serial is stored somewhere in SQLCA (unless my mind has truly turned to MUSH) - please help me remember Can I pick this off and return this value from a Stored Procedure? I know a SP returns a status but I thought that was just whether or not the SP executed properly - but it's been too damm long since I've written in SPL. Someone? Anyone?? Rob Vorbroker