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

Configuring Public Functions that Contain Private Functions

Configuring Public Functions that Contain Private Functions

When you include ports as arguments in a private user-defined function, you must also include the ports as arguments in any public function that contains the private function. Use the same datatype and precision for the arguments in the private and public function.
For example, you define a function to modify order IDs to include ‘INFA’ and the customer ID. You first create the following private function called ConcatCust that concatenates ‘INFA’ with the port CUST_ID:
CONCAT (‘INFA’, CUST_ID)
After you create the private function, you create a public function called ConcatOrder that contains ConcatCust:
CONCAT (:UDF.CONCATCUST( CUST_ID), ORDER_ID)
When you add ConcatCust to ConcatOrder, you add the argument CUST_ID with the same datatype and precision to the public function.
If you enter a user-defined function when you manually define the public function syntax, you must prefix the user-defined function with :UDF.


Updated June 25, 2018