Table Conversion System Functions

This table describes each system function that you can use in table conversion event rules:

System Function

Description

CopyTableDataSource

Enables you to copy a table or range of tables from one data source to another. The system copies tables based on specifications in the sign-in environment.

CopyTableEnvironment

Enables you to copy a table or range of tables from one environment to another. The system copies tables based on specifications in the input and output environments. If the specifications differ, the system performs a map-and-drop. This means that it creates a mapping between like fields in the source and destination tables and ignores all other fields.

TCInsertRow

The table conversion system inserts this system function when you select the Issue a write for this event? option and it cannot be moved. This function instructs the system that data should be written to the output table.

UserInsertRow

Enables you to specify when and where a row is inserted into the specified output table.

DeleteCurrentInputRow

Enables you to delete the current record from the input table.

UpdateCurrentInputRow

Enables you to update the current record in the input table after it has been modified.

SetSelectionAppendFlag

Enables you to determine whether selection criteria that is added by the system function SetUserSelection on the input table should be appended to the existing selection criteria or if it should replace the existing selection criteria.

SetUserSelection

Enables you to conditionally modify data selection on the input table. Call SetSelectionAppendFlag before calling SetUserSelection to indicate whether to replace or append to the existing data selection.