We are having problems with compiling SQL Stored Procedures that have the
"DECLARE EXIT HANDLER....." statement.

Compiler, from SCLM, gives us:
DSNH016I E DSNHPARS LINE 65 COL 12 "GLOBAL" REQUIRED
DSNH199I E DSNHPARS LINE 65 COL 12 INVALID KEYWORD "EXIT"; VALID SYMBOLS ARE: GLOBAL

DBA's can't get compiler options correct.
Any suggestions?

Exact code please.

One of the fun things about syntax errors is that the reported position is not necessarily the actual position. Sometimes an inappropriate use of a keyword will send the parser down some wild path, and the reported position is where the parser ends up - hence by "exact" I mean just that.

Doubt SCLM has anything to do with the problem - it's just driving the pre-pre-compile.

James Campbell

Can you post the entire source code for your procedure?