Store

[#1]

Hi,

is it possible to use store with where statements? and if it is, how is it used? can't seem to find anything in the help files..

Regards,
Kjetil

[Oleg_Troyansky · Accepted solution]

No, the syntax of Store doesn't include "where" clause. You can first load a separate table (remember to use NOCONCATENATE if you are loading exactly the same fields) with applied selection, and then store that table. For example:

OriginalTable:

load

A,B,C

from ...

LimitedTable:

NOCONCATENATE Load * resident OriginalTable where A>0;

store LimitedTable into myQVD.QVD;

drop table LimitedTable;

hope it helps,

Oleg