PH61301: ERROR "NOVALUE CONDITION RAISED" IN ADB22SQL WHEN USING PANEL OPTION 2.2, RUN OR EXPLAIN SQL STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using panel option 2.2, Run or Explain SQL Statements, a
  'Novalue condition raised' error is issued because fstmt is not
  initialized when it is used. fstmt is initialized and used only
  when pgmtype = 'PACKAGE'. So when pgmtype has other value,
  command on line 120 fails.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issuing a RUN or EXPLAIN command        *
  *                      on a COBOL program produces a           *
  *                      dialog error.                           *
  ****************************************************************
  When issuing a RUN or EXPLAIN command on a COBOL program,
  the following dialog error displays:
  
  Function : ADB22SQL, LINE 120: fstmt = strip(fstmt)
  Retcode  : 0
  Zerrmsg  :
  Zerrsm   : Novalue condition raised
  Zerrlm   : Error executing EXEC - now terminating
  

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:

  UI97729

Modules/Macros

• ADB22SQL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI97729

     UP24/07/24 P F407

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.