IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

When moving a cbl-db2 program to endevor it is abending


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kalyan.v

New User


Joined: 04 Feb 2008
Posts: 65
Location: Hyd

PostPosted: Mon Nov 02, 2009 4:13 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Mon Nov 02, 2009 4:21 pm
Reply with quote

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
View user's profile Send private message
kalyan.v

New User


Joined: 04 Feb 2008
Posts: 65
Location: Hyd

PostPosted: Mon Nov 02, 2009 4:28 pm
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Nov 02, 2009 7:48 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to pass the PARM value to my targ... COBOL Programming 8
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top