GETROWERROR

Description

The GETROWERROR() function returns an error message for any rows that fail when being processed. For successfully processed rows, an empty string is returned by default.

Syntax

GETROWERROR ( )

Remarks

This function is best used with the Update Source feature. When using GETROWERROR with Update Source, set Update Source to "Update source rows on success or failure."

Note: This function may produce unpredictable results when used with repeating data or bulk insert scenarios. TIBCO strongly suggests that you do not use GETROWERROR in these cases.

Examples

From the Update Source window, the following formula writes the error message from the failed target row to the source row:

GETROWERROR()

The following formula writes the specific error back to the source when the transaction generates an error. If there is no error, the formula returns "Success."

IF ( ISEMPTY (GETROWERROR() ), "Success", GETROWERROR() )