QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE table-name MUST BE SESSION, NOT qualifier

Conclusão: 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.

Ação do sistema: The statement was not executed.

Resposta ao Desenvolvedor: Change the statement in one of the following ways:

• Change the qualifier to SESSION.
• Remove the qualifier, and let DB2 default it to SESSION.

SQLSTATE: 428EK