467,189 Members | 1,305 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

Sqlstate = 56038

I am getting an SQLCODE = -4700, SQLSTATE = 56038 on
Below SQL returned - SQLCODE = -4700, SQLSTATE = 56038 We are on version 8 of DB2 but not in NFM yet
Expand|Select|Wrap|Line Numbers
  1. UPDATE    CORETSTA.DDA C                                  
  2.    SET   C.B1_ACCT_PROD_CD = (SELECT B1_ACCT_PROD_CD        
  3.                                   FROM CORETSTB.DDA B       
  4.                                  WHERE B.FINL_ENTY_ID =     
  5.                                          A.FINL_ENTY_ID     
  6.                                    AND B.ACCT_NBR =         
  7.                                          A.ACCT_NBR)        
  8.  WHERE EXISTS (SELECT 1                                     
  9.             FROM CORETSTB.DDA B                             
  10.                , CORETSTA.DDA A                             
  11.            WHERE A.FINL_ENTY_ID = '01'                      
  12.     AND B.FINL_ENTY_ID = A.FINL_ENTY_ID                     
  13.     AND B.ACCT_NBR = A.ACCT_NBR)             
  14.  
I modified the above and it worked..below is the modified one.
Expand|Select|Wrap|Line Numbers
  1. UPDATE  COREINTA.DDA  A                          
  2.    SET  ACCT_ANAL_CD  =                          
  3.        (SELECT ACCT_ANAL_CD                      
  4.           FROM COREINTB.DDA  X                   
  5.           WHERE X.FINL_ENTY_ID = A.FINL_ENTY_ID  
  6.             AND X.ACCT_NBR = A.ACCT_NBR)         
  7.  WHERE A.FINL_ENTY_ID = '01';
Jul 26 '07 #1
  • viewed: 9395
Share:
3 Replies
pbmods
Expert 4TB
Heya, Gene. Welcome to TSDN!

I'm going to go ahead and move this thread to the DB2 forum, where our resident Experts will be better able to help you out.
Jul 26 '07 #2
Shashank1984
FYI...
-4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE
SQLSTATE 56038: The requested feature is not supported in this
environment.

Most of the time the error 4700 is returned from DB2 zOS if running in
Compatibility Mode, and is just a Warning about some features could not
be used until New Mode is used.

This will help you ...
If your case is diff then paste the exact error msg from db2diag.log and give some details abt the exact environment DB2/OS/

Thanks and Regards,
Shashank K.
Jul 29 '07 #3
Hi
i am getting same -4700 SQL Code and sql state = 56038
STATEMENT=705
SQLCODE=-4700
SQLSTATE=56038

Here line 705 is my UPDATE statement which is giving me an error.
Can anyone plese tell me?
Oct 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Srinivas B.S.S | last post: by
5 posts views Thread by Jean-Marc Blaise | last post: by
3 posts views Thread by Jason Gyetko | last post: by
1 post views Thread by xf wang via DBMonster.com | last post: by
2 posts views Thread by Richard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.