Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Intelligent structure models
  9. Refining intelligent structure models
  10. Mapplets
  11. Saved queries
  12. Shared sequences
  13. User-defined functions

Components

Components

User-defined function expression

User-defined function expression

Create the expression that defines the function on the
Expression
tab. The function expression can contain constants, operators, built-in functions, and other user-defined functions. You can create a complex expression by nesting functions within functions.
To create an expression, enter the expression in the expression editor. The expression that you create must follow the same guidelines and use the same syntax as any transformation or field expression. For more information about creating expressions, see
Tasks
.
You can add arguments, built-in functions, and other user-defined functions to the expression by selecting them in the Arguments and Functions area of the expression editor and clicking
Add
. Alternatively, press the
Ctrl
+
Space
keys to see a list of recommended arguments and functions in-line. You can also type in the expression manually.
An expression cannot contain cyclic references. For example, the expression for user-defined function Function_A cannot include Function_A. Also, if user-defined function Function_A calls user-defined function Function_B, then the expression for Function_B cannot call Function_A.
To validate the expression, click
Validate
.
Data Integration
validates the expression. It does not validate the user-defined functions and expressions that use the function.

0 COMMENTS

We’d like to hear from you!