Parameters Panel
The Parameters panel is available for custom Java Procedures, SQL scripts, certain Transformations, Packaged Queries, and Parameterized Queries. This panel displays the input and output parameters for a procedure, and works with the SQL Script panel (or the SQL panel). The parameters you design in this panel must match the parameters defined in the SQL Script panel (or the SQL panel) including the order in which they are provided.
• For Java procedures and transformations, you can only view the parameters in the Parameters panel, because the parameters are defined in the source Java code (for a Java procedure) and in the XML or WSDL (for a transformation). Each parameter is displayed with its TDV JDBC data type and the data type native to the corresponding data source. The output parameters shown in this panel are rendered as columns in the result set when you execute the procedure.
• For a SQL script, packaged query, or parameterized query, use the Parameters panel to design and edit the parameters.