How do I get the .s.e sql interface on the command line?

Community Support
,
1

https://learninghub.kx.com/forums/topic/how-do-i-get-the-s-e-sql-interface-on-the-command-line

I have downloaded the on-demand 64bit version of kdb.

I launch the kdb+ as follows:

C:qw64q.exe

Then I create a simple table as follows:

t:([]k: 1 2 1; v:`A`B`C)

Then when I try to query it using the SQL interface as follows, I get the error:

.s.e"SELECT * FROM t"

'.s.e
[3] .s.e"SELECT * FROM t"

The command is not recognized.

How do I make it work?

2

Hi Ali99947,

The SQL module does not ship with standard version of KDB, such as 64 bit On-Demand.

It’ part of the KX Insights family of products. Please find more information here: About - KX Insights

Kind regards,

David