Available Operations

This table describes the operations that you can perform using the Table IO feature.

Operation	Description
FetchSingle	Combines the Select and Fetch options in a basic operation. Indexed columns are used for the Select option, and non-indexed columns are used for the Fetch option. The operation opens a table for input/output but does not close it.
Insert	Inserts a new row.
Update and Retain (Release 9.2.7)	Updates data in columns that are mapped for input, and for which input is provided. If a column is mapped for input but input is not provided, the data is retained with its existing value. Use this operation when you want to update mapped columns and retain existing data from the remaining mapped columns. Unmapped columns are not modified.
Update and Clear (This option is displayed as Update in the releases prior to 9.2.7)	Updates data in columns that are mapped for input, and for which input is provided. If a column is mapped for input but input is not provided, the data in the column is cleared. Use this operation when you want to update mapped columns and clear old data from remaining mapped columns. Unmapped columns are not modified.
Delete	Deletes one or more rows in a table.
Open	Opens a table or a business view.
Close	Closes a table or a business view.
Select	Selects one or more rows for a subsequent FetchNext operation. Click the Iterate Records button to automatically add a While loop to iterate over the resulting record set.
SelectAll	Selects all rows for a subsequent FetchNext operation. Click the Iterate Records button to automatically add a While loop to iterate over the resulting record set.
FetchNext	Fetches the rows that you specify. You can fetch multiple records with multiple FetchNext operations or with a single FetchNext operation in a loop.