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

Ports and Return Values

Ports and Return Values

When you write an expression that includes a port or return value from an unconnected transformation, use the reference qualifiers in the following table:
Reference Qualifier
Description
:EXT
Required when you write an expression that includes a return value from an External Procedure transformation. The general syntax is:
:EXT.external_procedure_transformation(argument1, argument2, ...)
:LKP
Required when you create an expression that includes the return value from an unconnected Lookup transformation. The general syntax is:
:LKP.lookup_transformation(argument1, argument2, ...)
The arguments are the local ports used in the lookup condition. The order must match the order of the ports in the transformation. The datatypes for the local ports must match the datatype of the Lookup ports used in the lookup condition.
:SD
Optional (PowerMart 3.5 expressions only). Qualifies a source table port in an expression. The general syntax is:
:SD.source_table.column_name
:SEQ
Required when you create an expression that includes a port in a Sequence Generator transformation. The general syntax is:
:SEQ.sequence_generator_transformation.CURRVAL
:SP
Required when you write an expression that includes the return value from an unconnected Stored Procedure transformation. The general syntax is:
:SP.stored_procedure_transformation( argument1, argument2, [, PROC_RESULT])
The arguments must match the arguments in the unconnected Stored Procedure transformation.
:TD
Required when you reference a target table in a PowerMart 3.5 LOOKUP function. The general syntax is:
LOOKUP(:TD.SALES.ITEM_NAME, :TD.SALES.ITEM_ID, 10, :TD.SALES.PRICE, 15.99)