Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Question Unanswered: SQL Stored Procedure Compile w/SCLM

    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?

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    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

  3. #3
    Join Date
    Apr 2002
    Location
    Chicago
    Posts
    10
    Can you post the entire source code for your procedure?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •