The Case Insensitive Data Loader agent migrates data from columns marked CaseInsensitiveSearch to shadow columns. The agent uses the transaction criteria to identify the records that need to be updated and then converts the original column values to lowercase values in the shadow columns. For more information about enabling case insensitive searches, refer to the Sterling Selling and Fulfillment Foundation: Extending the Database.
The Case Insensitive Data Loader agent is required for updating the existing data. Once the shadow columns have been created, the Case Insensitive Data Loader agent only needs to be run once for each table or table type. The shadow columns are then populated in real-time by the application.
The following are the attributes for this time-triggered transaction:
Attribute | Value |
---|---|
Base Transaction ID | DATA_LOADER |
Base Document Type | General |
Base Process Type | General |
Abstract Transaction | No |
APIs Called | None |
User Exits Called | None |
The following are the criteria parameters for this transaction:
Parameter | Description |
---|---|
Action | Required. Triggers the transaction. If left blank, it defaults to Get, the only valid value. |
Number of Records To Buffer | Optional. Number of records to retrieve and process at one
time.
|
CollectPendingJobs | If this parameter is set to "N", the agent does not collect information on the pending jobs for this monitor. This pending job information is used for monitoring the monitor in the System Management Console. |
TableType | Required in a multischema deployment when a table may exist
in multiple schemas. Valid Values: CONFIGURATION, TRANSACTION, MASTER. If set to CONFIGURATION, the agent runs for the records associated with tables that have TableType as CONFIGURATION. If set to TRANSACTION, the agent runs for the records associated with tables that have TableType as TRANSACTION. |
Table Name | Required. The table name for the records to be migrated to shadow columns. |
ColonyID | Required in a multischema deployment where a table may exist in multiple schemas. Runs the agent for the colony. |
None.
None.
None.