Re: Opinions on determining which constraint

[rob@xxxxxxxxx]

Rather tangential, but instead of retrieving messages from the calling 
procedure message queue, will not just checking the PSDS or the FINFDS 
give you the constraint name?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Paul Tuohy" <tuohyp@xxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
07/18/2004 05:45 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
Opinions on determining which constraint






Hi All,

I am looking for opinions/comments on how people identify which constraint 
caused a file exception error.

For the sake of brevity, let's just deal with check constraints. Here is 
what I am currently doing.

My program traps errors using the (E) extender on writes, updates etc.

If there is an error with a status of 1022, then a procedure is called 
which retrieves messages from the calling procedure message queue until it 
gets message CPF502F.

I then scan the message data looking for the constraint name - I have a 
naming convention that all constraint names start with CHECK_ . I am not 
ecstatic about using a naming convention to identify constraints.

I don't want to "hard code" the starting position of the constraint name 
in the message data - it may change in the future.

Does anybody have a different approach?

TIA

Paul Tuohy
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.