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...