| Filtering mechanism [message #16230] |
Wed, 07 June 2006 10:32  |
Eclipse User |
|
|
|
Once the connection is established, there is an option to enable filtering. My question: Is there a way to specify the filter for the schemas instead of pulling all the schemas from the database and selecting the ones you want? This is very costly in iSeries. I want to be able to specify, say a list of schemas that should be pulled in.
Second question - is there a way to do this programmatically?
|
|
|
|
| Re: Filtering mechanism [message #16368 is a reply to message #16283] |
Fri, 09 June 2006 14:06  |
| Eclipse User |
|
|
|
> Let me clarify: I did see the filtering mechanism where you can specify
something like schema "begins with characters" and "contains characters" etc.
I want to list the schemas. For example. I want schemas ABC , XYZ, WER etc. Is
there a way to list?
You can select the specific schema to list. However, that is driven off
the list of schema loaded into the model (which means you need to load all
the schema the first time through).
> Secondly, the schema names are case sensitive. Is that by design. Can that
be provided as an option?
This is a characteristic of the implementation. The catalog loaders use
the filter information specified when loading the model.
The generic JDBC catalog loader processes the results of
DatabaseMetaData.getSchemas() using java.lang.String functionality (e.g.
startsWith(), endsWith(), equals(), etc.).
Hope that helps.
Sincerely,
Rob Cernich
|
|
|
| Re: Filtering mechanism [message #579292 is a reply to message #16230] |
Thu, 08 June 2006 10:22 |
| Eclipse User |
|
|
|
Let me clarify: I did see the filtering mechanism where you can specify something like schema "begins with characters" and "contains characters" etc. I want to list the schemas. For example. I want schemas ABC , XYZ, WER etc. Is there a way to list?
Secondly, the schema names are case sensitive. Is that by design. Can that be provided as an option?
|
|
|
| Re: Filtering mechanism [message #579442 is a reply to message #16283] |
Fri, 09 June 2006 14:06 |
| Eclipse User |
|
|
|
> Let me clarify: I did see the filtering mechanism where you can specify
something like schema "begins with characters" and "contains characters" etc.
I want to list the schemas. For example. I want schemas ABC , XYZ, WER etc. Is
there a way to list?
You can select the specific schema to list. However, that is driven off
the list of schema loaded into the model (which means you need to load all
the schema the first time through).
> Secondly, the schema names are case sensitive. Is that by design. Can that
be provided as an option?
This is a characteristic of the implementation. The catalog loaders use
the filter information specified when loading the model.
The generic JDBC catalog loader processes the results of
DatabaseMetaData.getSchemas() using java.lang.String functionality (e.g.
startsWith(), endsWith(), equals(), etc.).
Hope that helps.
Sincerely,
Rob Cernich
|
|
|
Powered by
FUDForum. Page generated in 0.02788 seconds
Home