|SQL Completion in DTP 1.6RC1 [message #591238]
||Mon, 26 May 2008 19:39
| Stephen Schaub
Registered: July 2009
Eclipse 3.3.2 on XP SP2 with DTP 1.6.0 RC1 and DB2 8.1|
I am having some limited success with SQL completion in the SQL editor.
However, I am hoping for more, and wondering if the tool is functioning as
In the following query:
... when I type this much
(^ indicates cursor location) I get a list of table names in the AA
schema. That's nice. However, if I just type
and request completion, I don't get a list of schema names or tables. Is
there a way to request a list of schema names? Even better, I would like
to see a list of tables in the current schema. But I don't see a way to
set a current schema for the editor.
Regarding column completion, when I type the following:
and press Ctrl+Space at the ^ I get a list of column names in table BBBB.
However, when I request completion at the following location:
I get nothing. I would expect to see a list of columns from the tables in
the FROM clause - ?
By the way, I love the simplified connection profile creation in 1.6. A
vast improvement over earlier versions.
Powered by FUDForum
. Page generated in 0.01735 seconds