VARPG in conjunction with DB2 Constraints

FROM:   FLAGLER  KEENE     Flagler, Rick: Manager, IT                           
   

DATE:   JANUARY 21, 2000
SUBJECT:        VARPG in conjunction with DB2 Constraints                       
           


Has anyone used VARPG to update databases which have Referential 
constraints or Check constraints? I'd like to create my future DB files 
using these new technologies. I have been able to trap the error in my 
VARPG program, but I can't get an english langauge description of which 
REFCST or CHKCST field has triggered the DB add/update failure. 

If I use a DFU to do the same adds or updates, DFU catches the failures 
and shows a message with somewhat legible reasons. If I could get at 
these messages in VARPG, perhaps the constraint name at least, then I 
could tell the user what's happening rather than just display a message 
box saying "sorry, something is wrong with your input". If VARPG can't 
get at this from the INFDS File Feedback information area, then maybe 
alternatively I could call a CL to get it from the Job Message Queue some 
how? VARPG will certainly have this ability in a future release if not 
already, right? Any thoughts on this would be appreciated. Thanks. RF

------------------------------
Rick Flagler
Manager, IT 
Timken Super Precision (MPB)
Keene, NH