PM88618: RECEIVE SQLCODE = -270, ERROR: FUNCTION NOT SUPPORTED WHEN EXECUTING A SQL STATEMENT USING FM/DB2 OPTION 4.3

APAR status

• Closed as user error.

Error description

• When using FM/DB2 option 4.3 to execute a SQL statement such
  as:
  
   SELECT * FROM MYID.TESTVIEW FETCH FIRST 5 ROWS ONLY WITH UR
  
  receive message -
  
  DSNT408I SQLCODE = -270, ERROR:  FUNCTION NOT SUPPORTED
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• This is a probable user error and can be resolved by changes to
  the FMN2POPT module.
  When FM/DB2 has been set-up to use views of the DB2 catalog
  tables,(FMN2POPI parameter CATOWNER != SYSIBM) and the target
  DB2 system is at DB2 V9 NFM (New function mode) or later,
  the FMN2POPI parameter CATOWNERCDRM
  must be specified correctly.
  
  The correct value for the CATOWNERCDRM value can be determined
  using the following SQL statement.
  
  select rounding from sysibm.sysviews t1,
  sysibm.sysenvironment T2
  where name = 'SYSTABLES'
    and owner = 'SYSIBMV'        <- change SYSIBMV to CATOWNER
                                    parm value.
    and t1.envid = t2.envid
  
  This yields a single character.
  Use the following table to determine the appropriate
  CATOWNERCDRM value
  
  C ROUND_CEILING
  D ROUND_DOWN
  F ROUND_FLOOR
  G ROUND_HALF_DOWN
  E ROUND_HALF_EVEN
  H ROUND_HALF_UP
  U ROUND_UP
  
  See the File Manager Customization Guide,
  Appendix B: FM/DB2 Options for
  more information.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels