logo  
Google
 

DB2 SQL-Error: -079

SQLState: 428EK

Short Description: QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE MUST BE SESSION NOT

The qualifier for a declared temporary table must be SESSION. The DECLARE GLOBAL TEMPORARY TABLE statement defines a new temporary table named table-name with an explicit qualifier of qualifier. Specifying a qualifier other than SESSION is not allowed. System action: The statement was not executed. Programmer response: Change the statement in one of the following ways: v Change the qualifier to SESSION. v Remove the qualifier, and let DB2 default it to SESSION.

 <-  BACK TO INDEX