KX Community

Hi Guys,I have an sql query on KDB as follows: sql: "SELECT CUSIP, EXEC_PRC, TICK_TMSTMP, TICK_EFF_DT FROM TABLE WHERE "; sql,:"TICK_EFF_DT = TO_DATE('", (string x),"','YYYY.MM.DD') AND CUSIP IN ('", (string z),"') ";The parameters z and x in the sql...

Dear All,I stored some data in port 5000.When I try to read it from another command window i do:(1) h: hopen `::5000;(2) h" select from table where date= , time>="(3) close the connection using hclose hHowever, I have made a mistake at point 3) inste...

Hey Guys,I have created a partitioned/splayed table. For each country/each date, I've created a file that contains all the tickdata so if I want to extract the tickdata for a particular country i do: 1) I load the tickdata for a specific country (`:d...