8 2 6 Configure the Table Schema Substitution

8.2.6 Configure the Table Schema Substitution

Use the option Set Schema Substitution to assign the schema where tables are to be installed. The Schema Substitution also determines collection and owner properties applied to the table in the target database.

When tables are added to a package, a default Schema Substitution is derived and assigned based on the table properties and saved Settings.

Tables compiled before LANSA V13 and Other tables will automatically be assigned PARTLIB as the Schema Substitution, indicating the file should be installed at partition level.
Tables compiled with LANSA V13 or later will automatically be assigned PARTDTALIB as the Schema Substitution, indicating the file should be installed into the partition Default Table Schema level.

The following default Schema Substitutions are automatically created and cannot be modified, although they can be selected to apply to tables if they comply with the restrictions mentioned above:

Schema Substitution	Evaluated as
PARTLIB	Tables will install at partition level, for example: <sysdir>\X_DEM Schema, Collection and Owner information is derived from the file OAM and CTD included in the package.
PARTDTALIB	Tables will install at partition level, for example: <sysdir>\X_DEM<resolved value of PARTDTALIB> Schema, Collection and Owner information is derived from the resolved value of PARTDTALIB.
PARTPGMLIB	Tables will install at partition level, for example:<sysdir>\X_DEM<resolved value of PARTPTALIB> Schema, Collection and Owner information is derived from the resolved value of PARTPGMLIB.

To create an alternative Schema Substitution:

Step	How to do it
1. Create a Schema Substitution	In the Table Schema Substitutions, select the schema you wish to use, or create one by pressing the Create a Schema Substitution button to open the Schema Substitution Maintenance dialog.
2. Define the Schema Substitution	In the Schema Substitution Maintenance dialog, you can create a Schema Substitution to be used instead of the default values. Substitution Id You must specify a name by which to identify the Schema Substitution. The Schema Substitution Id must be ten characters or less, with the first character being an alphanumeric character. Do not use embedded blanks. Schema Substitution Enter your desired schema (library) name as a free-format entry.
3. Save the Schema Substitution	Press OK to save the schema substitution. You will be returned to the Table Schema Substitutions dialog.
4. Modify the Schema Substitution	To modify the schema substitution, delete the entry and re-enter the details as required.