Configure the following query in the SQL Editor:

SELECT SEQUENCE_NO from SEQUENCE_NUMBER;
UPDATE SEQUENCE_NUMBER 
Set SEQUENCE_NO =  SEQUENCE_NO + 1 ;

The following figure shows rows that the SQL transformation generates:

The SQL transformation returns two rows for each input row. The transformation returns one row for the SELECT statement and another row for the UPDATE statement in the query.

When a query contains a SELECT clause, the SQL transformation returns the data in the output ports, the pass-through ports, and the SQLError port.

When a query contains an UPDATE clause, the query returns no data from the database. The SQL transformation returns data to the SQLError port and the pass-through ports. Output ports return NULL values.

The SQLError port returns NULL when no SQL errors occur.