overwriting a compressed file

Community Support
1

Hi Group,

I am encountering an access error when I try to overwrite a compressed file which I can find no work around.

For instance when trying to change an entry on a compressed file

.z.zd:(17;2;6):tcompress set asc 10000000?100; :tcompress set @[get :tcompress;0;:;1000]`

I encounter an access error on a windows 7 box

ERROR: test. OS reports: Access is denied.

However if I try to append entries on a non compressed file I receive no errors

\x .z.zd:tfile set asc 10000000?100; .z.zd:(17;2;6):tfile set @[get :tfile;0;:;1000]`

Equally if I choose a different file name to overwrite then I receive no error

.z.zd:(17;2;6):tfile0 set asc 10000000?100; :tfile1 set @[get :tfile0;0;:;1000]`

Any ideas of how I might work around this?

Kind regards

David

2

it’s an unfortunate feature of windows - while a file is open it cannot be overwritten.

When reading compressed files, kdb+ keeps the file open.

Hence, I don’t know of another way other than choosing a different target name, and then rename afterwards.

hth,

Charlie