Eclipse Community Forums: DTP » Filtering mechanism

Help

Home

Home » Eclipse Projects » DTP » Filtering mechanism

Show: Today's Messages :: Show Polls :: Message Navigator

Filtering mechanism [message #16230]

Wed, 07 June 2006 14:32

Nazmin

Messages: 8
Registered: July 2009

Junior Member

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?

Report message to a moderator

Re: Filtering mechanism [message #16283 is a reply to message #16230]

Thu, 08 June 2006 14:22

Nazmin

Messages: 8
Registered: July 2009

Junior Member

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?

Report message to a moderator

Re: Filtering mechanism [message #16368 is a reply to message #16283]

Fri, 09 June 2006 18:06

Rob Cernich

Messages: 56
Registered: July 2009

Member

> 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

Report message to a moderator