Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Function Instance Row Processing Function

Function Instance Row Processing Function

PowerCenter calls this fnInstance_processRow when an input row is available to a custom function instance. The data for the input arguments of the custom function is bound and accessed through fnInstance-inputOPDHandles. Set the data, length, and indicator for the output and return ports in fnInstance->retHandle. PowerCenter calls the function-level initialization function before calling this function.
Use the following syntax:
INFA_EXPR_ROWSTATUS (*fnInstance_processRow) (INFA_EXPR_FUNCTION_INSTANCE_HANDLE fnInstance);
Argument
Datatype
Input/
Output
Description
fnInstance
INFA_EXPR_FUNCTION_HANDLE
Input
Function-level handle for which data is available.
The datatype of the return value is INFA_EXPR_ROWSTATUS. Use the following values for the return value:
  • INFA_ROWSUCCESS.
    Indicates the function successfully processed the row of data.
  • INFA_ROWERROR.
    Indicates the function encountered an error for the row of data. The PowerCenter Integration Service increments the internal error count. Only return this value when the data access mode is row.
  • INFA_FATALERROR.
    Indicates the function encountered a fatal error for the row of data or the block of data. The PowerCenter Integration Service fails the session.