Sets the update strategy for output rows. The setOutRowType method can flag rows for insert, update, or delete.
Use setOutRowType in the On Input Row section of the Java editor. You can use setOutRowType in active transformations that are configured to set the update strategy. If you use setOutRowType in an active transformation that is not configured to set the update strategy, the session generates an error and the session fails.
Use the following syntax:
setOutRowType(String rowType);
Argument
Data Type
Input/ Output
Description
rowType
String
Input
Update strategy type. Value can be INSERT, UPDATE, or DELETE.
Use the following Java code to propagate the input type of the current row if the row type is UPDATE or INSERT and the value of the input field input1 is less than 100, or set the output type as DELETE if the value of input1 is greater than 100:
// Set the value of the output field. output1 = input1;
// Get and set the row type. String rowType = getInRowType(); setOutRowType(rowType);
// Set row type to DELETE if the output field value is > 100. if(input1 > 100) setOutRowType(DELETE);