Class ITER_SQL

  • All Implemented Interfaces:
    IteratorFunction

    public class ITER_SQL
    extends IteratorStreamFunctionBase2
    Iterator function SQL issues a SQL query to a database.
    • Param 1: (database): the JDBC URI of the database
    • Param 2: (sql) the SQL query;
    The following variables may be bound:
    • Output 1 .. N: value of the ith column, encoded as a boolean, float, double, integer, string, dateTimeStamp, as it best fits.
    Author:
    Omar Qawasmeh, Maxime Lefrançois