By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Does Visual Explain work on a GLOBAL TEMPORARY TABLE?

P: n/a
DB2/SUN 8.1.6

================================================== ==========
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=>Create Access Plan

[IBM][CLI Driver][DB2/SUN] SQL0204N "SESSION.A" is an undefined
name. SQLSTATE=42704

B.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.