i am new to DB2 on ZOS.

i am trying to create a native SQL stored procedure failing with error.

SQL Error [56038]: ATTEMPT TO USE A FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL. SQLCODE=-4743, SQLSTATE=56038, DRIVER=4.31.10

and i tried to set the below parameter, and its still fails with the same error as above,

i tried to set the parameter to "V12R1" but it still fails with  same error.

any help would be appreciated, TIA

PTF BQU0718 will resolve the error message displayed on the screen and treat the -4743 as a warning.
 
You should check your ZPARM APPLCOMPAT value. You can use the Catalog Manager DSNZPARM command to see the value.
 
The -4743 is an ATTEMPT TO USE NEW FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL
 
If you receive this error, you probably bound the Catalog Manager packages with a ZPARM APPLCOMPAT of 10R1 or 11R1.
 
Catalog Manager needs packages bound with an APPLCOMPAT of at least V12R1M100 for DB2 V12 subsystems.  If you do not want to change your ZPARM APPLCOMPAT and want to resolve the -4743's, you will need to bind the Catalog Packages at V12R1M100. Please add APPLCOMPAT to the Package Bind JCL in HLQ.UBMCCNTL(ACT<ssid>P) and HLQ.UBMCCNTL(ACS<ssid>P) where SSID is the DB2 subsystem ID.
 
You cannot bind the packages at a function level higher than your current function level.
 
When you run the ACTIVATE command to change the DB2 levels, you should bind the Catalog Manager packages with the current function level. This will become more important as future enhancements of Catalog Manager and DB2 are delivered