Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Steps to Create a User-Defined Function

Steps to Create a User-Defined Function

Use the following procedure to create a user-defined function:
  1. Click Tools > User-Defined Functions > New.
    The Edit User-Defined Function dialog box appears.
  2. Enter a function name.
  3. Select a function type.
  4. Optionally, enter a description of the user-defined function.
    You can enter up to 2,000 characters.
  5. Create arguments for the user-defined function.
    When you create arguments, configure the argument name, transformation datatype, precision, and scale.
  6. Click Launch Editor to create an expression that contains the arguments you defined in step 5.
  7. Click OK.
    The Designer assigns the datatype of the data the expression returns.
  8. Click OK.


Updated June 25, 2018