#983 Shows me unusefull Entries

All
open
Gerd Wagner
8
2011-11-01
2011-05-17
Claus
No

Hi!

I hope I can describe what I mean :-)
Okay: This is i bigger Issue, so here my statement:

1. If I have a bigger Database and many Schematas which change very often, I don't use session Properties for Default schema -> I use set current schema.
But if I enter a Statement like
"select * from cu[STRG-Space]" I will get
schema1.customer
schema2.customer
schema3.customer

This is not usefull. My only way to avoid this is to use by default "select * from schema1.cu[STRG-Space] -> therefore I get what I want.
Is it possible and usefull for others to first show only Tables in my "currentschema" ?
Mabye as an Option STRG-Space used twice shows me all?

2. Next point:
If I enter a statement like
"select * from sysibm.sysdummy1 where [STRG-Space]"
at this point I get all available Tables again although at this Point columns should be shown.
Only way to avoid ist always to use Aliases like
"select * from sysibm.sysdummy1 d where d.[STRG-Space]"

(Same like select * from dual in Oracle)
So it is not context sensitive -> Is this changeable :-) ?

3. SQuirreL does have a problem if you try to enter a "exists-Querry" like:
"select * from sysibm.sysdummy1 d
where exists (select 1 from sysibm.sysdummy1 dd where dd.[STRG-Space]"
At this point you won't ever get a Code-Completion entry!

Only way to get this working:
"select * from sysibm.sysdummy1 d
where exists (
select 1 from sysibm.sysdummy1 dd where dd.[STRG-Space]"
Ahhh... I found at this moment: it seems to be a Problem not having a Space between ( and select !!

Discussion

  • Claus
    Claus
    2011-11-01

    • priority: 5 --> 8
     
  • Claus
    Claus
    2011-11-01

    Still not worked on?
    Especially Point 1 should be solved!