PH63836: DVM DISPLAYS SQL ENGINE OPEN-CURSOR - SQLCODE -1 - UNSUPPORTED STATEMENT TYPE FOR ORACLE JGATE TRYING TO USE CURSOR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DVM displays SQL ENGINE OPEN-CURSOR SQLCODE -1
  Unsupported statement type for ORACLE JGATE trying to use Cursor
  for the table in a COBOL program with IDF.
  Application runs with no issues the first time
  and gives the above error on subsequent runs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH63836                                 *
  *                      DVM displays SQL ENGINE OPEN-CURSOR -   *
  *                      SQLCODE -1 - Unsupported statement type *
  *                      for ORACLE JGATE trying to use Cursor   *
  *                      for the table in COBOL program          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH63836
  DVM displays SQL ENGINE OPEN-CURSOR - SQLCODE -1 - Unsupported
  statement type for ORACLE JGATE trying to use Cursor for
  the table in COBOL program
  

Problem conclusion

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:

Modules/Macros

• AVZCCACX AVZCCMAL AVZCSQCM AVZOAUCK AVZOBRIM AVZODMUT AVZOMAXM
  AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N
  AVZSQLBN AVZSQLCN AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI99110

     UP24/11/21 P F411

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.