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

Subscribe

You can track all active APARs for this component.

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 number

    PM88618

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655W4700

  • Reported release

    B12

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-07

  • Closed date

    2013-08-21

  • Last modified date

    2013-08-21

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

z/OS family

Software version:

B12

Reference #:

PM88618

Modified date:

2013-08-21

Translate my page

Machine Translation

Content navigation