View previous topic :: View next topic
|
Author |
Message |
kalyan.v
New User
Joined: 04 Feb 2008 Posts: 65 Location: Hyd
|
|
|
|
Hi,
when i am trying to move a cobol-db2 program to endevor it is abending with the following error code
DSNH4700I
description of the erroe is
DSNHSMF2 LINE 53 COL 30 ATTEMPT TO USE NEW FUNCTION WITH NEWFUN
NO
my program has only one select query as follows
EXEC SQL
SELECT COUNTY_NAME INTO :COUNTY-NAME
FROM (SELECT ROWNUMBER() OVER() AS RN,
COUNTY_NAME
FROM DWS_GEO_REGIONS
WHERE GEO_REGION = '4') T
WHERE RN = 2
END-EXEC.
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.
Thanks
kalyan.v |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
is that a new program or an existing one
the best places to ask would be the db2 and endevor support group in Your organization !
anyway to save some of Your precious time I looked up the message on your behalf...
here is the link
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNM1K15/8.155?SHELF=&DT=20091012143740&CASE=
DSNH4700I E csectname LINE nnnn COL cc ATTEMPT TO USE NEW FUNCTION WITH
NEWFUN NO
Explanation:
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.
System Action:
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.
Programmer Response:
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.
Severity: |
|
Back to top |
|
|
kalyan.v
New User
Joined: 04 Feb 2008 Posts: 65 Location: Hyd
|
|
|
|
HI,
Its a new program only, the problem is comming with the rownumber() function i used in the query, if i remove that function it is working properly
Thanks,
kalyan.v |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
because your DB2 is in DB2 9 Conversion Mode
upgrading to a new version of DB2 is in 3 steps : CM, ENFM and NFM
only in ENFM,NFM you can use the new features of DB2 9. |
|
Back to top |
|
|
|