Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: When moving a cbl-db2 program to endevor it is abending
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Mon Nov 02, 2009 4:21 pm    Post subject: Reply to: When moving a cbl-db2 program to endevor it is abe
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

http://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    Post subject:
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: 1280
Location: Belgium

PostPosted: Mon Nov 02, 2009 7:48 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us