PI16965: SQLCODE-270 ERRORS WHEN VIEWS ARE USED TO PROVIDE ACCESS TO THE DB2 CATALOG TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When attempting to view a DB2 object, receive the following
  messages:
  
   DSNT408I SQLCODE = -270, ERROR:  FUNCTION NOT SUPPORTED
   DSNT418I SQLSTATE   = 42997 SQLSTATE RETURN CODE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1. All users of File Manager DB2 component.  *
  *                 2. All users of File Manager.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. SQLCODE-270 errors when views of the *
  *                      DB2 catalog are used.                   *
  *                      2. ABENDS0C4 FMNED4D offset x'7AC'      *
  *                      after a DELETE ALL command in the       *
  *                      editor.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1. The code that determines the appropriate setting for the
  CURRENT DECFLOAT ROUNDING MODE (CDRM) special register is not
  setting the correct value in some situations, including:
  . After accessing DB2 objects at remote DB2 locations
  . After accessing DB2 views created with a CDRM that is
    different to the CDRM used when creating the views of the DB2
    catalog tables used by FM/DB2.
  2. The problem occurs when all lines in the editor are excluded
  and the 'DELETE ALL' command (no parameters) is entered.
  

Problem conclusion

• File Manager has been changed to correct the
  problems.
  

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:

  UI19499 UI19500 UI19501 UI19502 PI25319

Modules/Macros

• FMNASMX  FMNAUDCH FMNAUDDS FMNCBIN  FMNCBLX
  FMNCPCK  FMNCREXX FMNDB36  FMNDE69  FMNDSM03 FMNDYNTP FMNEDI
  
  ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
  

Fix information

• Fixed component name

  FILE MANAGER Z/

• Fixed component ID

  5655W6800

Applicable component levels

• RC1B PSY UI19501

     UP14/07/24 P F407

• RC10 PSY UI19499

     UP14/07/24 P F407

• RC12 PSY UI19500

     UP14/07/24 P F407

• RC13 PSY UI19502

     UP14/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.