Re: Opinions on determining which constraint

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.