Sample Database Tables and Structure

Edit online

The sample database, created during installation of Optim, is described in this Appendix. As a group, the database tables include information on customers, orders, shipping instructions, and so on.

Two files for demonstrating Move or Compare for IMS, VSAM, and Sequential File Dataare also provided and you can use the FOPNPRIV Extract File to create tables for use with the Column Map lookup functions or for other data privacy or data masking needs.

The data model contains related tables and Legacy files with the following names. Each table name has the Creator ID FOPDEMO.

OPTIM_CUSTOMERS
OPTIM_DETAILS
OPTIM_FEMALE_RATES
OPTIM_ITEMS
OPTIM_MALE_RATES
OPTIM_ORDERS
OPTIM_SALES
OPTIM_SHIP_INSTR
OPTIM_SHIP_TO
OPTIM_STATE_LOOKUP
OPTIM_ACTIONS
VENDITEM
VENDOR
DEPARTMENT
EMPLOYEE
POSITION
JOBCODE

The database also contains the following tables with the Creator ID FOPDEMO2. The tables with the Creator ID FOPDEMO2 are not populated during installation. These tables are used to demonstrate the facilities provided by Optim.

OPTIM_CUSTOMERS
OPTIM_DETAILS
OPTIM_ITEMS
OPTIM_ORDERS

Another table, FOPDEMO3.ACCOUNTS, is also used to demonstrate Optim. There are no distributed relationships for this table.