PowerCenter
- PowerCenter 10.5
- All Products
Task-Specific
Variables
| Description
| Task Types
| Datatype
|
---|---|---|---|
Condition
| Evaluation result of decision condition expression.
If the task fails, the Workflow Manager keeps the condition set to null.
Sample syntax:
| Decision
| Integer
|
EndTime
| Date and time the associated task ended. Precision is to the second.
Sample syntax:
| All tasks
| Date/Time
|
ErrorCode
| Last error code for the associated task. If there is no error, the Integration Service sets ErrorCode to 0 when the task completes.
Sample syntax:
You might use this variable when a task consistently fails with this final error message.
| All tasks
| Integer
|
ErrorMsg
| Last error message for the associated task.
If there is no error, the Integration Service sets ErrorMsg to an empty string when the task completes.
Sample syntax:
Variables of type Nstring can have a maximum length of 600 characters.
You might use this variable when a task consistently fails with this final error message.
| All tasks
| Nstring
|
FirstErrorCode
| Error code for the first error message in the session.
If there is no error, the Integration Service sets FirstErrorCode to 0 when the session completes.
Sample syntax:
| Session
| Integer
|
FirstErrorMsg
| First error message in the session.
If there is no error, the Integration Service sets FirstErrorMsg to an empty string when the task completes.
Sample syntax:
Variables of type Nstring can have a maximum length of 600 characters.
| Session
| Nstring
|
PrevTaskStatus
| Status of the previous task in the workflow that the Integration Service ran. Statuses include:
Use these key words when writing expressions to evaluate the status of the previous task.
Sample syntax:
| All tasks
| Integer
|
SrcFailedRows
| Total number of rows the Integration Service failed to read from the source.
Sample syntax:
| Session
| Integer
|
SrcSuccessRows
| Total number of rows successfully read from the sources.
Sample syntax:
| Session
| Integer
|
StartTime
| Date and time the associated task started. Precision is to the second.
Sample syntax:
SESSSTARTTIME returns the current date and time value on the node that runs the session after the Integration Service initializes the session. If a mapping or mapplet uses SESSSTARTTIME, StartTime and SESSSTARTTIME will have different values for a session.
| All tasks
| Date/Time
|
Status
| Status of the previous task in the workflow. Statuses include:
Use these key words when writing expressions to evaluate the status of the current task.
Sample syntax:
| All tasks
| Integer
|
TgtFailedRows
| Total number of rows the Integration Service failed to write to the target.
Sample syntax:
| Session
| Integer
|
TgtSuccessRows
| Total number of rows successfully written to the target
Sample syntax:
| Session
| Integer
|
TotalTransErrors
| Total number of transformation errors.
Sample syntax:
| Session
| Integer
|