Input Data for Maintenance Object

The extract for a maintenance object contains delimited data records for all tables included in the maintenance object. Depending on the conversion configuration, the CLOB data should be supplied either inline or in a separate, secondary files, one file per table containing CLOB. Refer to Notes on Secondary Data Files (CLOB Data) for limitations concerning XML CLOB data and more details.

Input Data File Names

Input data file names has to follow the rules described in this chapter. The names are case-sensitive.

File names for Maintenance Object contain Maintenance Object Code. If the code includes spaces or special characters, it should be replaced with '_', for example:

For actual MO Code: SP/MTR HIST, in the file name, use SP_MTR_HST

File Type	File Name
Single data file per Maintenance Object, no CLOB	File name equal target maintenance object name, such as PREMISE
Single data file per Maintenance Object, single CLOB column in the table, CLOB data in secondary file	Primary file name equal maintenance object name, such as PREMISE Secondary files name composed as maintenance object name concatenated with table name concatenated with '_CLOB'. For example, if PREMISE's CI_PREM table contains CLOB, the secondary file name is: PREMISE_CI_PREM_CLOB
Single data file per Maintenance Object, multiple CLOB columns in the table, CLOB data in secondary file	Primary file name equal maintenance object name, such as PREMISE For each CLOB column being uploaded, the secondary files name composed as maintenance object name concatenated with table name concatenated with CLOB column name concatenated with '_CLOB'. For example, if PREMISE's CI_PREM table contains two CLOB columns COL1 and COL2 , the secondary file names are: PREMISE_CI_PREM_COL1_CLOB, PREMISE_CI_PREM_COL2_CLOB
Multiple data file per Maintenance Object, no CLOB	File name is composed as target maintenance object name concatenated with file number, such as PREMISE1, PREMISE 2 etc
Multiple data file per Maintenance Object, single CLOB column in the table, CLOB data in secondary file	Primary file name is composed as target maintenance object name concatenated with file number, such as PREMISE1, PREMISE 2 etc Secondary files name composed as maintenance object name concatenated with table name concatenated with '_CLOB' concatenated with file number. For example, if PREMISE's CI_PREM table contains CLOB, the secondary file names are: PREMISE_CI_PREM_CLOB1, PREMISE_CI_PREM_CLOB2, etc
Multiple data file per Maintenance Object, multiple CLOB columns in the table, CLOB data in secondary file	Primary file name is composed as target maintenance object name concatenated with file number, such as PREMISE1, PREMISE 2 etc For each CLOB column being uploaded, the secondary files name composed as maintenance object name concatenated with table name concatenated with column name concatenated with '_CLOB' concatenated with file number. For example, if PREMISE's CI_PREM table contains two CLOB columns COL1 and COL2 , the secondary file names are: PREMISE_CI_PREM_COL1_CLOB1, PREMISE_CI_PREM_COL1_CLOB2, PREMISE_CI_PREM_COL2_CLOB1, PREMISE_CI_PREM_COL2_CLOB2 etc