PH26453: ADMIN TOOL PANEL ADB222 RUN SQL FROM DATA SET CREATE VIEW GREATER THAN 32765 SQL ERROR -104 / SQLCODE104N ILLEGAL SYMBOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using option 2.2 (panel ADB222, 'Run or Explain SQL
  Statements') to execute sql statements from a data set, a CREATE
  VIEW statement which is longer then 32765 characters may fail
  with SQL error -104 / sqlcode104n.  For example:
  
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "H". SOME SYMBOLS
   THAT MIGHT BE
  LEGAL ARE: <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT HOLD FREE
  ASSOCIATE
  DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = 3 0 0 -1 32766 502 SQL DIAGNOSTIC INFORMATION
  DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000'
  X'FFFFFFFF'
  X'00007FFE' X'000001F6' SQL DIAGNOSTIC INFORMATION
  
  
  Note:  The character specified in the error message is character
  32766, and so will vary according to the contents of the
  statement.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who use panel ADB222 to run SQL         *
  *                 statements from a data set.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: CREATE VIEW statements fail with        *
  *                      message DSNT408I when they are run from *
  *                      panel ADB222.                           *
  *                                                              *
  *                                                              *
  ****************************************************************
  When the Run or Explain SQL Statements
  (ADB222) panel is used to run SQL
  statements from a data set, any
  CREATE VIEW statements longer
  than 32765 characters fail.
  
  Example error:
  
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "H". SOME SYMBOLS
  THAT MIGHT BE LEGAL ARE: <ERR_STMT> <WNG_STMT> GET SQL SAVEPOINT
  HOLD FREE ASSOCIATE
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI70489

Modules/Macros

• ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70489

     UP20/07/14 P F007

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.