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

Custom Function Pushdown Function

Custom Function Pushdown Function

PowerCenter calls pushdownFunction to generate SQL code for pushdown optimization.
Use the following syntax:
INFA_EXPR_STATUS pushdownFunctionEcho(IUNICHAR* sNameSpace, IUNICHAR* sFuncName, IUINT32 numArgs, INFA_EXPR_OPD_METADATA** inputArgList, EDatabaseType dbType, EPushdownMode pushdownMode, IUNICHAR** sGenSql)
Argument
Datatype
Input/Output
Description
sNameSpace
IUNICHAR
Input
Namespace of the function.
sFuncName
IUNICHAR
Input
Name of the custom function to validate.
numArgs
IUNINT32
Input
Number of arguments in the custom function.
inputArgList
INFA_EXPR_OPD_METADATA
Input
Input arguments of the custom function.
dbType
EDatabaseType
Input
Database type.
pushdownMode
EPushdownMode
Input
Type of pushdown optimization.
sGenSql
IUNICHAR
Output
SQL generated by the custom function.
The return datatype is
INFA_EXPR_STATUS
. Use ISUCCESS and IFAILURE as the return value. When the function returns IFAILURE, PowerCenter displays an error message.