Skip to main content

Generic_JDBC_Connection.read

readsql_querylimit

Group: Input
Aliases: import, load

Documentation​

Execute a raw SQL query or read the contents of a table by name.

Arguments​

  • sql_query: Either a table name or a raw SQL query.

Returns​

  • the resulting rows as an in-memory table.

Examples​

Run a raw SQL query.​

      connection = Generic_JDBC_Connection.connect "jdbc:h2:~/my_database"
      table = connection.read (SQL_Query.Raw_SQL "select a, b, c from foo")

Read the contents of a table.​

      connection = Generic_JDBC_Connection.connect "jdbc:h2:~/my_database"
      table = connection.read (SQL_Query.Table_name "foo")