Content-Disposition: inline
i remember in the days before Q, kdb was a superset of standard SQL – has this been abandoned?
Jack,never there to be abandoned :-)kdb+ (and kdb) both support a subset of sql92 to allow access via ODBC/JDBC but q and earlier ksql were never a direct supersetyou can execute sql92 in kdb+ by prefacing your command with s) - ODBC+JDBC do this automaticallybut there’s no good reason to do so unless you have toq)\l trade.q,0(+(,sym)!,,a)!+(,`size)!,100q)tradetime sym price size---------------------------09:30:00.000 a 10.75 100q)select from tradetime sym price size---------------------------09:30:00.000 a 10.75 100q)select * from trade’typeq)s)select * from tradetime sym price size---------------------------09:30:00.000 a 10.75 100q)/SimonOn Aug 8, 7:58?am, “Jack Andrews” <effb…> wrote:> i remember in the days before Q, kdb was a superset of standard SQL – has> this been abandoned?</effb…>
see also the examples at the end of s.k at:http://kx.com/q/s.k2008/8/9 simon <simon.garland>:>> Jack,>> never there to be abandoned :-)> kdb+ (and kdb) both support a subset of sql92 to allow access via ODBC/> JDBC but q and earlier ksql were never a direct superset>> you can execute sql92 in kdb+ by prefacing your command with s) - ODBC> +JDBC do this automatically> but there’s no good reason to do so unless you have to</simon.garland>