PowerCenter
- PowerCenter 10.5
- All Products
Reference Qualifier
| Description
|
---|---|
:EXT | Required when you write an expression that includes a return value from an External Procedure transformation. The general syntax is:
|
:LKP | Required when you create an expression that includes the return value from an unconnected Lookup transformation. The general syntax is:
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:
|
:SEQ | Required when you create an expression that includes a port in a Sequence Generator transformation. The general syntax is:
|
:SP | Required when you write an expression that includes the return value from an unconnected Stored Procedure transformation. The general syntax is:
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:
|