| SQL Completion in DTP 1.6RC1 [message #591238] |
Mon, 26 May 2008 19:39 |
 Stephen Schaub
Messages: 13
Registered: July 2009 |
Junior Member |
|
|
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
designed.
In the following query:
SELECT *
FROM AA.BBBB
... when I type this much
SELECT *
FROM AA.^
(^ indicates cursor location) I get a list of table names in the AA
schema. That's nice. However, if I just type
SELECT *
FROM ^
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:
SELECT AA.BBBB.^
FROM AA.BBBB
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:
SELECT ^
FROM AA.BBBB
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.23852 seconds
] 
Search
Help
Register
Login
Home
