Is there a way to un-enumerate a column in the hdb? One of thesecolumns is causing the sym file to grow out of control.
you’ll need to cast it to a string - use dbmaint.q from kx site
i don’t think you can unenumerate unless you write out a whole new list of course
If you want to roll your own, something along the lines (for all datesof course) should work.You should test it against a dev DB that you can mess up first ofcourse!As another posted noted though, dbmaint should be able to do this justfine…/ Splayed HDBhdb: “/path/to/hdb/“hhdb: hsym $hsymdates: (key hhdb) where (key hhdb) like "[0-9][0-9][0-9][0-9].[0-9][0-9].[0-9][0-9]"{[dat; tableName; colName] -1 "Amending date: ",string date; / hsym to column col: hsym $(string date),”/”,(string tableName),“/”,colName; / Column attributes a: attr col; / read column, cast to string, apply attributes and write back todisk col set a#string get col;}[;“table”;“badCol”] each dates;On Nov 26, 5:53?pm, Dal Mon <dalae…> wrote:> Is there a way to un-enumerate a column in the hdb? ?One of these> columns is causing the sym file to grow out of control.</dalae…>