Staging Control Parameters Layout

If your staging control record should read a database table, the XAI service may include selection criteria in its WHERE clause. If that is the case, then your staging control record should populate the selection criteria. The name of this table is CI_​​XML_​​STGCTL_​​P. The following table describes each column on this table.

Column Name Length Req'd Data Type Comments
XML_​​STG_​​CTL_​​ID 10 Y N The unique identifier of the staging control record.
XML_​​STG_​​CTL_​​PARM 18 Y A/N Indicate the element in the WHERE clause whose value will limit the selection of records.
XML_​​STG_​​CTL_​​PVAL 250 Y A/N Use this to indicate the value used to limit selection of records.