Hi
We are using Baan IVc4 with Informix. Baan stores all tables in one database for live and test companies. We have approx. 30,000 tables in Baan Database.
Is there a way where we can select one table or tablenames which are having some common suffix etc.
Any help would be highly appreciated.
regards
Muhammad Usman
musman@iffco.com
Listserv Archives (BOB member since 2002-06-25)
Hi, Muhammad.
To limit the tables that come up in the Table Browser, you will have to use an External Strategy.
For more information on doing this, consult the Designer’s Guide, Ch. 4, “Creating External Strategies;” and the Informix Database Guide, pg. 79, “Configuring and External Strategy File.” Others on the ListServ also have much experience in external strategies.
The following example is for a STRUCT strategy, which is used to populate the tables you see in the Table Browser. The example is for Oracle. Use the Stifxen.txt file in the Informix directory to get started for the Informix version. (Below I had a quick sample of what the strategy may look like for Informix.) You can include the text for the STRUCT strategy at the end of the Stifxen.txt file. The important thing is to have the SELECT clause follow the required format for a STRUCT strategy: 1. Table Qualifier
2. Table Owner
3. Table Name
4. Column Name
5. Data Type (C (Character), N (Numeric), D (Date), T (Long Text). If the column is left empty, the default is C)
6. Null? (can be null values in columns?: Y (Yes) or N (No). Default is unknown)
Listserv Archives (BOB member since 2002-06-25)