Micro Focus XDBC offers convenient ways to manage multiple company data sets. For example, you may have two sets of data for Company01 and
Company02. The layouts of the data files are the same, but the file names have different prefixes or suffixes. For example,
ACCT01 and
ACCT02 may be the accounting files for Company01 and Company02, respectively. They are stored in different directories.
Rather than having to set up system catalogs for each of your companies individually, you can do one of two things:
- You can have a different configuration file for each company. In this configuration file, you can use wildcards and substitution
characters to identify which data files to access, allowing you to have a single system catalog that gets populated only once
and yet supports more than one company
- You can set up a separate schema for each company, and then you can specify which table to access. For example, you could
set up a schema for "acme" and a separate schema for "generic," and then qualify your SQL statements.