lib

lib:sql

SQL connector

meta

def	lib:sql
depends	lib:ph, lib:axon, lib:hx, lib:conn, lib:skyarc
is	lib
lib	lib:sql
version	3.1.11

docs

Overview • Setup • Connectors • Funcs • His Sync

tags

sqlConn	SQL connector to a relational database using JDBC
sqlConnRef	Used on a proxy point to reference its parent `sqlConn`
sqlHis	Arbitrary key used by the SQL connector to synchronized history data
sqlPoint	Point which synchronizes data via a SQL connector
sqlSyncHisExpr	This is a tag which must be configured on each `sqlConn` record used by the `connSyncHis()` function

funcs

sqlDebugDrivers	Return plain text report on JDBC drivers installed
sqlExecute	Execute a SQL statement and if applicable return a result
sqlInsert	Insert a record or grid of records into the given table
sqlPing	Deprecated - use `connPing()`
sqlQuery	Execute a SQL query and return the result as a grid
sqlSyncHis	Deprecated - use `connSyncHis()`
sqlTables	Query the tables defined for the database