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.
|
|
