By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Sqlstate = 56038

P: 1
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
Share this Question
Share on Google+
3 Replies


pbmods
Expert 5K+
P: 5,821
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
P: 26
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

P: 1
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.