Hello,
we are working with DB2 for z/OS v12 and have done...
ACTIVATE FUNCTION LEVEL (V12R1M501)
********************************* Top of Data **********************************
DSNU757I -DBCG DSNUGCCA
*** BEGIN ACTIVATE FUNCTION LEVEL (V12R1M501)
FUNCTION LEVEL (V12R1M501) SUCCESSFULLY ACTIVATED
CATALOG LEVEL(V12R1M500)
CURRENT FUNCTION LEVEL(V12R1M501)
HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M501)
HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501)
DSN9022I -DBCG DSNZACMD '-ACTIVATE FUNC' NORMAL COMPLETION
******************************** Bottom of Data ********************************
i.e. activated FUNCTION LEVEL V12R1M501 like above, where you see the success message as well.
Nevertheless when running the following statement via JDBC:
CREATE VIEW X_VIEW_PARAMETERS AS SELECT MID, MLVL1, MLVL2, MNAME, SRCTYPE, LISTAGG(CAST(DNAME AS VARCHAR(8000)), ',') WITHIN GROUP (ORDER BY DSEQPOS) AS PARAMNAMES, LISTAGG(CAST(SUBSTR(DSUBTYPE,1,1) || LENGTH AS VARCHAR(8000)), ',') WITHIN GROUP (ORDER BY DSEQPOS) AS PARAMTYPES, SUM(LENGTH) AS PARAMLEN, COUNT(*) PARAMNBR FROM X_VIEW_DATAS WHERE ATTRIBUTES LIKE '%FRMPAR%' GROUP BY MID, MLVL1, MLVL2, MNAME, SRCTYPE;
it' failing with message:
ATTEMPT TO USE A FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL. SQLCODE=-4743, SQLSTATE=56038, DRIVER=4.22.29
We appreciate any hint or help, what to do or where to search. We feel to have searched, read and tried hundreds of hints in multiple Forums but nothing was solving the problem.
Kind regards
Andreas Gronert
------------------------------
Andreas Gronert
------------------------------
#Db2forz/OS