8.2.4 Table Data Processing

Use the option Data Processing option to determine if table data should be included when deploying the table and how to manage any existing table data – if the table already exists – in relation to new table data.

 

To avoid unnecessarily unloading and reloading table data when installing later versions of an Application where the table definitions have not changed, use the option Exclude data, Reload existing.  This is the default value applied when a patch is created.

The following processing options are available:

Table Data option

Action

Exclude data, Drop existing

No table data is included in the package.  If the table already exists, all data will be removed.

Exclude data, Reload existing

No table data is included in the package.  If the table already exists, all data will be retained.

When installing patches, if the table definition has not changed, this option should be used to avoid unloading and reloading table data.

This is the default option.

Include data, Drop existing

Table data is included in the package.  If the table already exists, all data will be removed and package data will be loaded.

Include data, Ignore duplicates

Table data is included in the package.  If the table already exists, all data will be retained and package data will be loaded.  Any duplicate records in the package data will be ignored.

Include data, Replace duplicates

Table data is included in the package.  If the table already exists, all data will be retained and package data will be loaded.  Any duplicate records in the package data will replace the existing record.

Include data (new tables only)

This option is deprecated. It will be removed in the next release.

Table data is included in the package and will be installed if the table does not already exist.

If the table already exists in the application no processing of the table data will occur.

Include data (existing tables only), Drop existing

This option is deprecated. It will be removed in the next release.

Table data is included in the package but will only be installed if the table already exists.  Any pre-existing table data is not reloaded.

Include data (existing tables only), Ignore duplicates

This option is deprecated. It will be removed in the next release.

Table data is included in the package but will only be installed if the table already exists.  Any pre-existing table data is reloaded after the new table data and duplicate records in the package data will be ignored.

Include data (existing tables only), Replace duplicates

This option is deprecated. It will be removed in the next release.

Table data is included in the package but will only be installed if the table already exists.  Any pre-existing table data is reloaded before the new table data and duplicate records in the package data will replace the existing record.