PipeMeter

Description

Occurs during pipeline processing after each block of rows is read or written. The Commit factor specified for the Pipeline in the Pipeline painter determines the size of each block.

Event ID

Event ID

Objects

pbm_pipemeter

Pipeline

Arguments

None

Returns

Long. Return code choices (specify in a RETURN statement):

Usage

The Start and Repair functions initiate pipeline processing.

In the Pipeline painter, you can specify a Commit factor specifying the number of rows that will be transferred before they are committed to the database. The PipeMeter event occurs for each block of rows as specified by the Commit factor.

For a complete example of using a Pipeline object, see Application Techniques.

Examples

Example 1

This code in a Pipeline user object’s PipeMeter event report the number of rows that have been piped to the destination database:

ist_status.Text = String(This.RowsWritten) &

   + " rows written to the destination database."

See also