Case insensitive data loader

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.

Attributes

The following are the attributes for this time-triggered transaction:

Table 1. Case insensitive data loader attributes
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

Criteria parameters

The following are the criteria parameters for this transaction:

Table 2. Case insensitive data loader criteria parameters
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.
  • If left blank or the number specified is less than 10000, it defaults to 5000.
  • If the number specified is greater than 10000, then that value is used.
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.

Statistics tracked

None.

Pending job count

None.

Events raised

None.