| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| limit database tables |
« View previous topic :: View next topic » |
| Author |
Message
|
| francoisvdm |
 Posted: Tue Jul 07, 2009 12:40 am Post subject: limit database tables |
 |
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
This msg was by accident also posted in the Interchange forum...sorry. do not know how to remove it from there.
I can't find the "filter" in V6.1 to limit the number of tables returned for a database definition. I can filter on schema name, but that is all...
Any suggestions? I know in version 6.0 I could specify a filter "LIKE SYS.ABC.*"
The problem is that with thousands of tables I think the toolkit is running out of memory creating everything.
Thanks
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Jul 07, 2009 3:11 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Francois,
Have you tried with a PASSTHROUGH 'LIKE ''SYS.ABC.%'' ' which would be more in keeping with SQL syntax? You could also use the prepared statement 'LIKE ?' and then supply the value as 'SYS.ABC.%' ... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Tue Jul 07, 2009 3:47 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
This is still in "creating" the DB connections...anybody have a "statement" for me I can pop into the filter field?
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
