Stored procedure

Posted in 2005

Topics: Stored Procedures & SPL, Error Codes & Troubleshooting

Nirmala Kesavan — Mon, 19 Dec 2005 19:13:15 -0800 (PST) — source: Usenet: comp.databases.informix

hi, I am using informix dynamic server 7.2 . how do i use SQLCA.SQLCODE in a stored procedure . thanks and regards , Nirmala __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com sending to informix-list

↪ replying to Nirmala Kesavan

Jonathan Leffler — Tue, 20 Dec 2005 06:23:34 GMT — source: Usenet: comp.databases.informix

Nirmala Kesavan wrote: > I am using informix dynamic server 7.2. how do i use SQLCA.SQLCODE in > a stored procedure. You should not still be using IDS 7.2 (even 7.24 is not a good idea). ON EXCEPTION is the primary mechanism - see the SPL chapter in the SQL Syntax manual. If you're lucky, DBINFO might help - but then again, it might not since I can no longer remember whether the support for SQLCA elements was added to 7.2x or whether that was new with 7.3x. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/