Table 142. Updatable Special Registers
Special Register                                Updatable  
CLIENT ACCTNG                                   Yes  
CLIENT APPLNAME                                 Yes  
CLIENT USERID                                   Yes  
CLIENT WRKSTNNAME                               Yes  
CURRENT DATE                                    No  
CURRENT DBPARTITIONNUM                          No  
CURRENT DEFAULT TRANSFORM GROUP                 Yes  
CURRENT DEGREE                                  Yes  
CURRENT EXPLAIN MODE                            Yes  
CURRENT EXPLAIN SNAPSHOT                        Yes  
CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION Yes  
CURRENT PATH                                    Yes  
CURRENT QUERY OPTIMIZATION                      Yes  
CURRENT REFRESH AGE                             Yes  
CURRENT SCHEMA                                  Yes  
CURRENT SERVER                                  No  
CURRENT TIME                                    No  
CURRENT TIMESTAMP                               No  
CURRENT TIMEZONE                                No  
USER                                            No  

DB2 Special Registers
SPECIAL REGISTER                                UPDATE 
=============================================== ====== 
CURRENT CLIENT_ACCTNG                           no     
CURRENT CLIENT_APPLNAME                         no     
CURRENT CLIENT_USERID                           no     
CURRENT CLIENT_WRKSTNNAME                       no     
CURRENT DATE                                    no     
CURRENT DBPARTITIONNUM                          no     
CURRENT DEFAULT TRANSFORM GROUP                 yes    
CURRENT DEGREE                                  yes    
CURRENT EXPLAIN MODE                            yes    
CURRENT EXPLAIN SNAPSHOT                        yes    
CURRENT ISOLATION                               yes    
CURRENT LOCK TIMEOUT                            yes    
CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION yes    
CURRENT PACKAGE PATH                            yes    
CURRENT PATH                                    yes    
CURRENT QUERY OPTIMIZATION                      yes    
CURRENT REFRESH AGE                             yes    
CURRENT SCHEMA                                  yes    
CURRENT SERVER                                  no     
CURRENT TIME                                    no     
CURRENT TIMESTAMP                               no     
CURRENT TIMEZONE                                no     
CURRENT USER                                    no     
SESSION_USER                                    yes    
SYSTEM_USER                                     no     
USER                                            yes