Datafeed Toolbox™

kx - Connect to Kx Systems^®, Inc. kdb+ databases

Syntax

K = kx(IP,P)
K = kx(IP,P,ID)

Arguments

Description

K = kx(IP,P) connects to the Kx Systems, Inc. kdb+ database given the IP address IP and port number P.

K = kx(IP,P,ID) connects to the Kx Systems, Inc. kdb+ database given the IP address IP, port number P, and username:password string ID.

Before you connect to the database, add The Kx Systems, Inc. file jdbc.jar to the MATLAB^® javaclasspath using the javaaddpath command. The following example adds jdbc.jar to the MATLAB javaclasspath c:\q\java:

javaaddpath c:\q\java\jdbc.jar

Note   In earlier versions of the Kx Systems, Inc. kdb+ database, this jar file was named kx.jar. If you are running an earlier version of the database, substitute kx.jar for jdbc.jar in these instructions to add this file to the MATLAB javaclasspath.

Examples

Run the following command from a DOS prompt to specify the port number 5001:

q tradedata.q -p 5001 

Connect to a Kx Systems, Inc. server using IP address LOCALHOST and port number 5001:

K = kx('LOCALHOST',5001) 
handle: [1x1 c]
        ipaddress: 'localhost'
        port: 5001

See Also

kx.close, kx.exec, kx.get, kx.fetch, kx.tables

idc.isconnection

kx.close