=============== =============== =============== ===============
About DB2 Administration Tools Environment
=============== =============== =============== ===============
DB2 administration tools level:
Product identifier SQL08015
Level identifier 02060106
Level DB2 v8.1.5.449
Build level s040212
PTF WR21334
=============== =============== =============== ===============
Java development kit (JDK):
Level IBM Corporation 1.3.1
=============== =============== =============== ===============
Does Visual Explain work on a GLOBAL TEMPORARY TABLE?
From Command Center, on the Script tab:
Execute: DECLARE GLOBAL TEMPORARY TABLE A (A INT)
Clear the window and execute: SELECT * FROM SESSION.A
Both are successful.
Menu=>Script=>C reate Access Plan
[IBM][CLI Driver][DB2/SUN] SQL0204N "SESSION.A" is an undefined
name. SQLSTATE=42704
B.