RE: Receive Program Message From RPGIV using embedded SQL

Andrew, 

if I remember correctly, SQL0530/SQL0532 is the error message that you get
when a referential constraint is violated and if SQL0545 is the error
message id you got a check Constraint error. 
The SQLERM variable of the SQLCA contains the constraint name, library,
etc.... 

IF the constraint name is not enough, You can retrieve the table names and
the field names also. You can also retrieve trigger error messages when the
sql msgid is SQL0443. If you need this information, pls. let me know and I
can post some pseudocode. 

 

 

-----Original Message-----
From: Andrew.Lutz@abbott.com [mailto:Andrew.Lutz@abbott.com]
Sent: Friday, June 15, 2001 7:47 PM
To: RPG400-L@midrange.com
Subject: Receive Program Message From RPGIV using embedded SQL


I would like to retrieve the message being generated for a constraint
violation.

I have attempted to use QMHRCVPM for this purpose to no avail.....

What I am specifically after is the constraint name.

This would be one of the things to execute after....

IF SQLCOD < 0
     Retrieve message here
ENDIF

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---