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

Reserved Words

Reserved Words

Some keywords in the transformation language, such as constants, operators, and built-in variables, are reserved for specific functions. These include:
  • :EXT
  • :INFA
  • :LKP
  • :MCR
  • :SD
  • :SEQ
  • :SP
  • :TD
  • AND
  • DD_DELETE
  • DD_INSERT
  • DD_REJECT
  • DD_UPDATE
  • FALSE
  • NOT
  • NULL
  • OR
  • PROC_RESULT
  • SESSSTARTTIME
  • SPOUTPUT
  • SYSDATE
  • TRUE
  • WORKFLOWSTARTTIME
The following words are reserved for workflow expressions:
  • ABORTED
  • DISABLED
  • FAILED
  • NOTSTARTED
  • STARTED
  • STOPPED
  • SUCCEEDED
You cannot use a reserved word to name a port or local variable. You can only use reserved words within transformation and workflow expressions. Reserved words have predefined meanings in expressions.