DB2 - CHAR9 is not accepted by IBM Supplied Programs

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

Hi Team,
Our DB2 subsystem is in V11 NFM mode .BIF_COMPATIBILITY is set as CURRENT now .

As per IBM advice,

www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/inst/src/tpc/db2z_ipf_bifcompatibility.html

We are trying to use CHAR9 instead of CHAR for impacted DB2 objects .While testing for IBM supplied programs like DSNTEP2 ,DSNTEP4,DSNTIAUL and DSNTIAD we were getting error

DSNT408I SQLCODE = -4743, ERROR: ATTEMPT TO USE A FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A
PREVIOUS LEVEL
we are in V11 NFM mode already and wondering what is stopping us to use CHAR9 .

Any thought on this ?

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

In addition ,

Application compatiility is set as V10R1
and CHAR9 related error is not expected as per below IBM documentation
www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/apsg/src/tpc/db2z_applcompatv10r1.html

guptae · Posted: Thu Mar 12, 2020 2:08 pm

Hello there,

Could you please share the sql where you have used char9?

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

Query is simple like below
SELECT CHAR9(ACCOUNT)
FROM EMPLOYEE
WHERE EMPLOYEE_NR = 12345

Here ACCOUNT is declared as Decimal in table

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

After rebind of IBM supplied programs issue is resolved .