This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] I suppose what you could do is retrieve message CPF502D from your joblog, strip the file and library names from the message data, and use this information to display the object description. So Message ID . . . . . . : CPF502D Severity . . . . . . . : 30 Message type . . . . . : Notify Date sent . . . . . . : 04/24/02 Time sent . . . . . . : 10:24:53 Message . . . . : Referential constraint violation on member TPNBR. Cause . . . . . : The operation being performed on member TPNBR file TPNBR in library WEB failed. Constraint QSYS_ROLECODE_00001 prevents record number 0 from being inserted or updated in member TPNBR of dependent file TPNBR in library WEB because a matching key value was not found in member ROLE of parent file ROLE in library WEB. If the record number is zero, then the error occurred on an insert operation. The constraint rule is 2. The constraint rules are: 1 -- *RESTRICT 2 -- *NOACTION Recovery . . . : Either specify a different file, change the file, or change the program. Then try your request again. Possible choices for replying to message . . . . . . . . . . . . . . . : C -- The request is canceled. I -- The request is ignored. Becomes: Message ID . . . . . . : USR0001 Severity . . . . . . . : 30 Message type . . . . . : Notify Date sent . . . . . . : 04/24/02 Time sent . . . . . . : 10:24:53 Message . . . . : Record not found in ROLE-'Role Types' Cause . . . . . : Unable to add record to TPNBR-'Cross ref of Logins to databases' because there is no match for ROLE-'Role Types'. Recovery . . . : Select a valid value from the drop down. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin Finucci Domenico <Domenico.Finucci@Fiditalia.it> Sent by: firstname.lastname@example.org 04/24/2002 09:47 AM Please respond to midrange-l To: "'email@example.com'" <firstname.lastname@example.org> cc: Fax to: Subject: R: R: SQL help In other words, in order to send a message such: "an order item is being loaded while no order exist" you need to know the constraint details, is that true ? I was asking if a more general purpose approch exists. Sincerely Domenico Finucci Fiditalia , Milano, 02- 4301-2494 -----Messaggio originale----- Good question. What message do you currently send when a write to a file fails? Or is the common practice of ignoring the indicator, or whatever, on a write employed. Rob Berendt _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact