PK62696: QMF MSGDSQ10498 WITH SQLCODE -330 SQLCODE330N SQLSTATE 22021 & "SQLERRM16: FORM EXECEPTION(FOR EXAMPLE, INVALID MIXED DATA)."

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• QMF MSGDSQ10498 with SQLCODE -330 SQLCODE330N SQLSTATE 22021 &
  "SQLERRM16: Form exeception(for example, invalid MIXED DATA)."
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: QMF for TSO/CICS DBCS users, such as    *
  *                      Japanese, who have QMF queries, procs   *
  *                      or forms with names greater than 18     *
  *                      bytes in length can experience a SQL    *
  *                      code -330 during QMF processing. QMF    *
  *                      for TSO/CICS SBCS users, such as        *
  *                      English, who have QMF queries, procs or *
  *                      forms with names greater than 18 bytes  *
  *                      will notice that the LAST_USED column   *
  *                      of the Q.OBJECT_DIRECTORY table is not  *
  *                      updated in certain circumstances.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During update of the LAST_USED column of the Q.OBJECT_DIRECTORY
  column for QMF queries, procs and forms that have names greater
  than 18 bytes in length, the length column was not set
  correctly. This led to the SQL code -330 condition for DBCS
  users and no update for SBCS (English, German, Italian, etc.)
  users.  This problem does not happen in all circumstances, just
  when the UPDATE had to be queued up waiting for prior activity
  to finish.
  

Problem conclusion

• Module DSQIFSQL has been fixed to set the long name switch
  for queued updates.
  

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:

  UK34774 UK34775

Modules/Macros

• DSQIFSQL
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK34774

     UP08/03/22 P F803

• R910 PSY UK34775

     UP08/03/22 P F803

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.