when i am trying to move a cobol-db2 program to endevor it is abending with the following error code
description of the erroe is
DSNHSMF2 LINE 53 COL 30 ATTEMPT TO USE NEW FUNCTION WITH NEWFUN
my program has only one select query as follows
SELECT COUNTY_NAME INTO :COUNTY-NAME
FROM (SELECT ROWNUMBER() OVER() AS RN,
WHERE GEO_REGION = '4') T
WHERE RN = 2
When i searched in ibm help it is showing to include NEWFUN yes option
please let me know where to include this option in endevor.
DSNH4700I E csectname LINE nnnn COL cc ATTEMPT TO USE NEW FUNCTION WITH
When the SQL processing option NEWFUN has a value of NO, you cannot use syntax for functions that this release of DB2 introduces. An attempt was made to use one of these functions.
If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.
Do one of these things:
Restrict your program to functions that earlier releases of DB2 introduced. These functions are allowed regardless of the value of NEWFUN.
Process your program with a value of YES for the NEWFUN option. However, you cannot BIND the DBRM until New Function Mode has been enabled.