Store Statement

Salvatore99a — Tue, 26 Feb 2019 18:24:24 GMT

Hello,

I was wondering if there is a difference between the following:

Store * from (tablename) into...

and

Store (tablename) into...

If there is a difference between them what is it and which one would result in greater optimization.

Thank you in advance!

Re: Store Statement

afbraga1 — Wed, 27 Feb 2019 09:51:00 GMT

Hello Salvatore99a,

table1:
LOAD * Inline[
1,2
1,1
];

These 2 methods are the same since you are storing all table fields;

store * from table1 into xx.qvd(qvd);
store table1 into xy.qvd(qvd);

But if you do it like the method below you will only store a specific field.

store '2' from table1 into xx.qvd(qvd);

Best regards,

André Braga