Table of Contents

Search

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

Transformation Language Reference

Transformation Language Reference

User Interface Validation Function

User Interface Validation Function

When PowerCenter calls INFA_EXPR_ValidateGetUserInterface, the plug-in returns function pointers to the validation functions.
Use the following syntax:
INFA_EXPR_STATUS INFA_EXPR_ValidateGetUserInterface( IUNICHAR* sNamespace, IUNICHAR* sFuncName, INFA_EXPR_VALIDATE_METHODS* functions);
Argument
Datatype
Input/
Output
Description
sNamespace
IUNICHAR
Input
Namespace of the custom function.
sFuncName
IUNICHAR
Input
Name of the custom function.
functions
INFA_EXPR_VALIDATE_METHODS
Output
Pointers to different functions called during validation and reporting.
The return datatype is
INFA_EXPR_STATUS
. Use ISUCCESS and IFAILURE as the return value. When the function returns IFAILURE, the plug-in did not implement the function or another error occurred.
INFA_EXPR_ValidateGetUserInterface returns the following functions:
  • validateFunction.
    Validates a custom function.
  • getFunctionDescription.
    Describes a custom function.
  • getFunctionPrototype.
    Provides the prototype for a custom function.
  • pushdownFunction.
    Generates SQL code for pushdown optimization.