Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Salvatore99a
Contributor
Contributor

Store Statement

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!

1 Solution

Accepted Solutions
afbraga1
Creator
Creator

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

View solution in original post

1 Reply
afbraga1
Creator
Creator

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