ODBC
The APIs in this module relate to using kdb+ as an ODBC client. This functionality is described in full here.
The required scripts, .so
and .dll
files are bundled with Control so downloading them isn't required.
Target DSN and required drivers must be setup on the server
.odbc.close
Closes an ODBC connection
Parameter:
Name | Type | Description |
---|---|---|
x | int | Connection handle |
Example:
.odbc.close[h]
.odbc.eval
Evaluates an SQL expression against a target handle
Parameters:
Name | Type | Description |
---|---|---|
x | int | Connection handle |
y | string | SQL query |
Returns:
Type | Description |
---|---|
table | SQL results set |
Example:
sel:"select CompanyName,Phone from Customers where City='London'"
.odbc.eval[h;sel]
/=> CompanyName Phone
/=> ----------------------------------------
/=> "Around the Horn" "(171) 555-7788"
/=> "B's Beverages" "(171) 555-1212"
/=> "Consolidated Holdings" "(171) 555-2282"
/=> ..
.odbc.load
Loads the entire target database
Parameter:
Name | Type | Description |
---|---|---|
x | string | symbol | ODBC connection string |
Example:
.odbc.load `northwind
tables[]
/=> `Categories`Customers`Employees`OrderDetails`Orders`Products`Shippers`Supplie..
Shippers
/=> ShipperID| CompanyName Phone
/=> ---------| -----------------------------------
/=> 1 | "Speedy Express" "(503) 555-9831"
/=> 2 | "United Package" "(503) 555-3199"
/=> 3 | "Federal Shipping" "(503) 555-9931"
.odbc.open
Opens an ODBC connection to a target data source
Parameter:
Name | Type | Description |
---|---|---|
x | string | symbol | ODBC connection string |
Returns:
Type | Description |
---|---|
int | Connection handle |
Example:
h:.odbc.open `northwind
.odbc.tables
Lists the tables in the database
Returns:
Type | Description |
---|---|
symbol[] | List of tables |
Example:
.odbc.tables h
/=> `Categories`Customers`Employees`Order Details`Orders`Products...
.odbc.views
Lists the views in the database
Returns:
Type | Description |
---|---|
symbol[] | List of views |
Example:
.odbc.views h
/=> `Alphabetical List of Products`Category Sales for 1997`Current...