PK23304: INVALID CONTINUATIONS GENERATED FOR EXPORTED SQL TEXT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When QM ends a string, within a SQL statement,
  * with a non-blank character in col 72 of an export dataset and
  * QM places the next token of the SQL statement in column 1
       of the next line of the dataset
  SQL errors are encountered when the user then attempts to run
  the SQL text, contained in the export dataset, through SPUFI.
  
  SQLCODE104 -104 SCQLCODE199 -199
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Query Monitor.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When QM ends a string, within a SQL     *
  *                      statement, with a non-blank             *
  *                      character in col 72 of an export        *
  *                      dataset and QM places the next token    *
  *                      of the SQL statement in column 1        *
  *                      of the next line of the dataset SQL     *
  *                      errors are encountered when the user    *
  *                      then attempts to run the SQL text,      *
  *                      contained in the export dataset,        *
  *                      through SPUFI.                          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK14096

Modules/Macros

•    CQM$TEXT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK14096

     UP06/05/11 P F605

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.