Developer Transformation Guide

10.4.1
- 10.5.2
- 10.5
- 10.4.0

Back Next

SQL Transformation Ports

When you create an SQL transformation, the Developer tool creates the SQLError port by default. Add input ports, output ports, and pass-through ports in the

Ports

view.

The SQL transformation has the following types of ports:

Input: Receives source data that you can use in an SQL query.
Output: Returns database data from an SQL SELECT query.
Pass-through: Input-output ports that pass source data through the transformation without changing it.
SQLError: Returns SQL errors from the database. If no errors occur, returns NULL.
NumRowsAffected: Returns the total number of database rows affected by INSERT, DELETE, and UPDATE query statements for an input row. The Developer tool creates this port when you choose to include the update statistics in the output row.
Return Value: Receives the return value from a stored procedure.