Query Database Operator

Use the Query Database operator to issue a single SQL statement against the database. This operator supports the JDBC escape syntax. The Query Database operator uses CallableStatement and ParameterMetaData to gather information about the input and output parameters prior to and after statement execution. If the JDBC driver does not support this behavior, the Generic SQL operator may not be able to gather all of the results from the SQL statements. Additionally, the JDBC driver supplied by the database vendor may not support the use of all data types with the JDBC driver. For example, the SQL Server JDBC driver does not support the SQL Server sql_variant data type. Always refer to your JDBC driver documentation for more information on what JDBC features and data types are supported by the driver.