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
 

 

-4700 sqlcode- DB2 ATTEMPT TO USE NEW FUNCTION BEFORE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Surya Kira nPasumarthi

New User


Joined: 21 Nov 2007
Posts: 19
Location: hyderabad

PostPosted: Mon Aug 11, 2008 12:33 pm    Post subject: -4700 sqlcode- DB2 ATTEMPT TO USE NEW FUNCTION BEFORE
Reply with quote

Hi,

I am trying to write a Coorealted subquery to update the description of a table column using below query:

update picsh_ms_loss loss
set loss.loss_desc = (select CASE C.LOSS_DESC_CODE
WHEN '481' THEN 'DUE TO TORNADO'
WHEN '482' THEN 'DUE TO APPLIANCE FAILURE'
WHEN '483' THEN 'DUE TO PLUMBING FAILURE'
WHEN '485' THEN 'DUE TO ICE DAM'
FROM TPLCC2.COM_CLAIMS C , TPIX15.PICSH_MS_POLSTAT P,
TPIX15.PICSH_MS_LOSS L
WHERE C.CLAIM_NO = L.CLAIM_NO
AND L.CLAIM_NO <> ' ' AND L.LOSS_DESCR_30 = ' '
AND P.STATUS_CODE IN ('A' , 'R')
AND P.POL_NUM = C.POLICY_NO
and loss.policy_ref_num = p.policy_ref_num
and loss.claim_no = c.claim_no)

when i am trying to excute the above query,

I am getting an error with sqlcode = -4700
DB2 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE.

Please let me know, if there is any error in the above query.

Thanks in advance.

Thanks,
SK
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Mon Aug 11, 2008 2:34 pm    Post subject:
Reply with quote

The primary error is that you are trying to use a new function before it has been activated. Talk to your DBA about it.
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Mon Aug 11, 2008 6:43 pm    Post subject:
Reply with quote

Which version of DB2 are you using.???. I guess this error message comes on DB2 V8 Compatible mode.

Are you running on V8 CM.??
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
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm
No new posts Replace function abdulrafi COBOL Programming 13 Mon Sep 12, 2016 10:12 am
No new posts Which function does the Ampersand (&a... Andi1982 PL/I & Assembler 3 Wed Aug 24, 2016 2:05 pm


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