Re: R: R: SQL help

[rob@xxxxxxxxx]

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: midrange-l-admin@midrange.com
04/24/2002 09:47 AM
Please respond to midrange-l


        To:     "'midrange-l@midrange.com'" <midrange-l@midrange.com>
        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-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.