#580 Custom Schema Properties

[Claus]

Hi,

we have many connections to databases and we have many schematas in Database we want to use.
If we connect to DB2 System i - we get many Systemtables we dont want to see (all starting "Q")
Example:
MYSCHEMA1
MYSCHEMA2
MYSCHEMA3
MYSCHEMA4
Q1ABRMSF01
QBRM
QCA400W
QCAEXP
QCTX
QDEVTOOLS
QDIRSRV2
QDNS
QDOC
QDSNX
QFNTCPL
QGPL
QGPLTEMP
QGY
QHLPSYS
QHTTP
QHTTPSVR
QICSS
QINMEDIA
QINPRIOR
QINSYS
QIWA2
QIWS
QJAVA
QJVM7032
QJVM7064
QJVM8032
QJVM8064
QLWIRADM
QMGTC
QMGTC2
QMSE
QNAVACS
QNAVSRV
QOAR
QPASE
QPDA
QPFR
QPFRDATA
QPFRHIST
QPFRTEMP
QPTFOBJ1
QPTFOBJ2
QQALIB
QQRYLIB
QRCL
QRECOVERY
QRPG
QRPGLE
QRPGLEP
QRPLOBJ
QSC6544911
QSC6544912
QSERVICE
QSHELL
QSPL
QSQL
QSRV
QSRVAGT
QSYS
QSYS2
QSYSCGI
QSYSDIR
QSYSV7R1M0
QSYSV7R2M0
QTCP
QTEMP
QUSRBRM
QUSRDIRCF
QUSRDIRDB
QUSRSYS
QUSRTEMP
QUSRTOOL
QXMLSERV

It would be nice if there would be an Option to change Session Properties to ignore specific Schematas using Wildcards.
Current sollution: Change Schema Properties, Connect to Database, select "Do not Load Any" and select Schemata I want to Load.
As we change our Schemanames often, this is not helpfull.

Greetings Claus

[Gerd Wagner]

Committed to our GIT repository. Will be available in future snapshots and versions.

Excerpt from change log:
Alias properties allows SQL LIKE syntax to configure schema loading:
Menu Windows --> View Aliases --> select an Alias --> menu Aliases --> Alias properties --> tab Schemas
--> section "Set ... in all Schemas ..." now has a small button next to the word "to" that opens a filter text field.
The filter allows to use % and _ as wildcards much like the SQL LIKE syntax.

[Claus]

Hi Gerd,
firstly - thanks for this solution. It will help me, but is not exactly what I intended ( 80% ;-) ).
Is it possible to define this "LIKE scheme" so it will be appended dynamically?
In your solution I have to open Session Properties every time a new schema has been added...
Please keep the current solution - it works at last for me, but is not as convenient as it could be...

[Gerd Wagner]

Claus,
I just committed a new feature that may increase your 80% a bit. Here's the excerpt from our change log:
New option in "Alias Schema properties": Filter schemas by name.
See right mouse on Alias --> Alias properties --> tab Schemas --> third radio button.
This feature was introduced especially for databases with very many Schemas.
It may help to shorten SQuirreL's startup and shutdown time.
If this feature is used the Schema table (on the same panel) should be cleared, too.

Gerd