Sqlstate = 56038

[Gene McCusker]

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

UPDATE    CORETSTA.DDA C                                  
   SET   C.B1_ACCT_PROD_CD = (SELECT B1_ACCT_PROD_CD        
                                  FROM CORETSTB.DDA B       
                                 WHERE B.FINL_ENTY_ID =     
                                         A.FINL_ENTY_ID     
                                   AND B.ACCT_NBR =         
                                         A.ACCT_NBR)        
 WHERE EXISTS (SELECT 1                                     
            FROM CORETSTB.DDA B                             
               , CORETSTA.DDA A                             
           WHERE A.FINL_ENTY_ID = '01'                      
    AND B.FINL_ENTY_ID = A.FINL_ENTY_ID                     
    AND B.ACCT_NBR = A.ACCT_NBR)             
 

I modified the above and it worked..below is the modified one.

UPDATE  COREINTA.DDA  A                          
   SET  ACCT_ANAL_CD  =                          
       (SELECT ACCT_ANAL_CD                      
          FROM COREINTB.DDA  X                   
          WHERE X.FINL_ENTY_ID = A.FINL_ENTY_ID  
            AND X.ACCT_NBR = A.ACCT_NBR)         
 WHERE A.FINL_ENTY_ID = '01';

[pbmods]

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.

[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.

[nihar2007]

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?