PM37412: CREATE STORED PROCEDURE GETS SQLCODE = -104 ERROR. NSP TO ADD ANOTHER VERSION : ILLEGAL SYMBO 11/04/20 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS GETS A SQLCODE -104 WHEN
  DOING A CREATE STORED PROCEDURE OR WHEN ALTERING A NSP TO
  ADD ANOTHER VERSION.
  MESSAGE: ILLEGAL SYMBOL "NONEBEGIN"
  SYMPTOM: SQLCODEN104
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who create stored procedures, alter     *
  *                 stored procedures, or edit the stored        *
  *                 procedure body whose statement length        *
  *                 is less than or equal to 18 on panel         *
  *                 ADB26COQ 'Create SQL Stored Procedure        *
  *                 Body'.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when creating a stored procedure body,  *
  *                      altering a stored procedure, or editing *
  *                      the body whose statement length is      *
  *                      less than or equal to 18 on panel       *
  *                      ADB26COQ, two errors occur:             *
  *                                                              *
  *                      1. The SQL statement keyword of         *
  *                      stored procedure is connected           *
  *                      with the statement in the body of       *
  *                      stored procedure. Executing the         *
  *                      SQL statement will cause an             *
  *                      SQLCODE=-104/SQLCODEN104                *
  *                      error:                                  *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "NONEBEGIN".             *
  *                      SOME SYMBOLS THAT MIGHT BE              *
  *                      LEGAL ARE: NONE ALWAYS ONCE             *
  *                                                              *
  *                      2. A semicolon is added at the end      *
  *                      of the create statement of stored       *
  *                      procedure. Executing the SQL            *
  *                      statement will cause a                  *
  *                      SQLCODE=-104/SQLCODEN104                *
  *                      error:                                  *
  *                                                              *
  *                      DDSNT408I SQLCODE = -104, ERROR:        *
  *                      ILLEGAL SYMBOL ";". SOME SYMBOLS        *
  *                      THAT MIGHT BE                           *
  *                      LEGAL ARE: <END-OF-STATEMENT>           *
  *                      <IDENTIFIER>                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Creating a stored procedure, altering a stored procedure,
  or editing the stored procedure body whose statement
  length is less than or equal to 18 on the ADB26COQ panel
  results in SQLCODE=-104/SQLCODEN104 errors.  The
  create or alter statement is invalid.
  

Problem conclusion

• Program has been modified to generate the correct create or
  alter statement of a stored procedure.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK68261 UK68262

Modules/Macros

•    ADB2A2WS ADB26COQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK68261

     UP11/06/02 P F106

• R720 PSY UK68262

     UP11/06/02 P F106

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.