public java.lang.String getPrevStepLog(java.lang.String pPropertyName)
Returns information about the most recently executed step in a package. The information requested is specified through the pPropertyName parameter. If there is no previous step (for example, if the getPrevStepLog step is executed from outside a package), the exception "No previous step" is raised.
Parameter |
Type |
Description |
---|---|---|
pPropertyName |
String |
String that contains the name of the requested property about the previous step. See the list of valid properties below. |
The following table lists the different possible values for pPropertyName:
Parameter value |
Description |
---|---|
SESS_NO |
The number of the session. |
NNO |
The number of the step within a package. The first step executed is 0. |
STEP_NAME |
The name of the step. |
STEP_TYPE |
A code indicating the type of step. The following values may be returned:
|
CONTEXT_NAME |
The name of the context in which the step was executed. |
MAX_ERR |
The maximum number or percentage of errors tolerated. |
MAX_ERR_PRCT |
Returns 1 if the maximum number of errors is expressed as a percentage, 0 otherwise. |
RUN_COUNT |
The number of times this step has been executed. |
BEGIN |
The date and time that the step began. |
END |
The date and time that the step terminated. |
DURATION |
Time the step took to execute in seconds. |
STATUS |
Returns the one-letter code indicating the status with which the previous step terminated. The state R (Running) is never returned.
|
RC |
Return code. 0 indicates no error. |
MESSAGE |
Error message returned by previous step, if any. Blank string if no error. |
INSERT_COUNT |
Number of rows inserted by the step. |
DELETE_COUNT |
Number of rows deleted by the step. |
UPDATE_COUNT |
Number of rows updated by the step. |
ERROR_COUNT |
Number of erroneous rows detected by the step, for quality control steps. |
Previous step '<%=odiRef.getPrevStepLog("STEP_NAME")%>' executed in '<%=odiRef.getPrevStepLog("DURATION")%>' seconds.