checking instances of tables and paths

Hi,

I have two further questions about loading instances of tables into kdb - forgive me if this is obvious

  1. What is the best way to check for a loaded instance of a table in the namespace? Is the follow the best way to do this

 

any((tables .) = MyTable

 

where MyTable is the name of the table I am trying to check if it is loaded 

  1. When a partition tables is loaded into the namespace is it possible to see the path name?

tmem:(dt:date$ 2014.02.13 2014.03.13;bid:float$1.283 1.387)

`:c:/q/splay/tsplay/ set tmem

\l c:/q/splay

\v

s#tmem`tsplay

I would like to know what the path to tsplay is…

Many thanks

David 

 

 

Hey,

  1. you can try:

MyTable in tables.

to avoid the “any” part?

  1. When the partition table is loaded, your current directory should be the path to the partition table:

\pwd  //linux

\cd  //windows

>>> your current directory should be the path to the partition table:<o:p></o:p>

<o:p> </o:p>

You can check it using key `:.<o:p></o:p>

<o:p> </o:p>

Kim<o:p></o:p>

<o:p> </o:p>

Von: personal-kdbplus@googlegroups.com [mailto:personal-kdbplus@googlegroups.com] Im Auftrag von WooiKent Lee
Gesendet: Mittwoch, 19. Februar 2014 10:41
An: personal-kdbplus@googlegroups.com
Betreff: [personal kdb+] Re: checking instances of tables and paths<o:p></o:p>

<o:p> </o:p>

Hey,<o:p></o:p>

<o:p> </o:p>

  1. you can try:

MyTable in tables.

to avoid the “any” part?<o:p></o:p>

<o:p> </o:p>

  1. When the partition table is loaded, your current directory should be the path to the partition table:<o:p></o:p>

<o:p> </o:p>

\pwd  //linux<o:p></o:p>

\cd  //windows