need additional data from get diagnostics

Posted in 2000

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Triggers, Constraints & Referential Integrity

Eric.Egdorf@mci.com — Thu, 13 Apr 2000 22:02:29 GMT — source: Informix-list mailing list archive (1991-1998)

We have an insert failing on a foreign key constraint in an ESQL program but can't figure out how to retrive the FK name from get diagnostics. The msg_text field doesn't contain the data.

↪ replying to Eric.Egdorf@mci.com

Jonathan Leffler — Fri, 14 Apr 2000 04:07:23 GMT — source: Informix-list mailing list archive (1991-1998)

Eric.Egdorf@mci.com wrote: > We have an insert failing on a foreign key constraint in an ESQL > program but can't figure out how to retrive the FK name from get > diagnostics. The msg_text field doesn't contain the data. Hmmm, don't know about GET DIAGNOSTICS, but I'd expect the constraint name to be in sqlca.sqlerrm -- translating it into something more meaningful is not completely trivial, which is why DB-Access doesn't bother to try (nor does SQLCMD). -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Glossary

ESQL/C