Error Handling in SQLRPGLE Programs

["Bob Slaney" <rjslaney@xxxxxxxxxx>]

I am wondering what you do about error handling in embedded SQL programs.
Checking SQLCOD values of 0 or 100 is a start. WHENEVER is better than
nothing. Has anyone written an error handling module and put it in a
service program? If so, can you describe your logic? I am trying to design
an error handling architecture and a dose of practical experience would
validate (or otherwise) my thinking.

Thanks.

Bob

Bob Slaney/Atlanta/IBM@IBMUS (Lotus Notes)
Internet id: rjslaney@us.ibm.com
VM id: DALVM1.RJSLANEY@VM

Tieline  445-7374 Direct (770)835-7374
FAX tie 445-7579 Direct (770)835-7579
IBM Learning Services
iSeries Courseware Developer
IBM Corp.
3200 Windy Hill Road
Atlanta, GA 30339
WG07C13