cookbook:"If you have a table that contains columns of type symbol withrepeated elements (ie, the table is not fully enumerated), trying tosave the table splayed will result in an error ('type):q)trdate open high low close volume sym-------------------------------------------------2006.10.03 24.5 24.51 23.79 24.13 19087300 AMD2006.10.03 27.37 27.48 27.21 27.37 39386200 MSFT2006.10.04 24.1 25.1 23.95 25.03 17869600 AMD2006.10.04 27.39 27.96 27.37 27.94 82191200 MSFT…q)`:tr/ set tr’typeThe reason is that tables that are splayed across a directory must befully enumerated and not keyed. The solution is to enumerate columnsof type varchar before saving the table splayed. This is done with thefunction .Q.en."shows how to splay a table with only one column as varchar. Myquestion is how to splay tables with multiple varchar columns? Whatabout keyed tables?Thanks,db
On 25.11.2009, at 01:38, dbtouch wrote:> question is how to splay tables with multiple varchar columns? What> about keyed tables?.Q.en will deal with all columns of type symbol, it’s not restricted to only one you pass it the directory where the sym file lives and the whole table - it then looks at the column types to work out what it has to doyou can’t splay keyed tables