Applies to
TIB_DataPump

Declaration
Property DPItemActions : TIB_StringList;

Description
This property tells how the column assignments were made upon preparing the process. Call Prepare and then analize the contents of this property to make sure that everything lines up as expected.

It's format is a standard list of link entries with the columns of the input row as the link entries.

There are four possible results:

DIRECT is the best which means that the output and input SQLData & SQLInd pointers are referencing the same point in memory such that no processing needs to occur between the fetch for the output row and the execute to submit the data from the input row.

ASSIGNMENT is the next best which means that a DataPumpItem has been assigned to handle the conversion of the data from the output buffer to the input buffer. By default the Assign() method is used so that generic data type conversions can automatically be performed. Specialized alternate classes of TIB_DPItemBase can be used to handle non-standard data conversions. These will also show up in this category.

UNASSIGNED means that it was unable to associate the input column with any data in the output column. This either means that your DstLinks property has a typo in it or that you intend to handle the data conversion manually by writing an event handler in the AfterFetchRow event.

SKIPPED means that it is not possible to make any association for the specified column and that it will not be processed. This will only happen if you are using a SELECT statement that includes a readonly or COMPUTED column.