Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to store same qvd in different places, with single store statement (i.e giving two different paths in single store statement)
John
I don't think you can do it with a single store statement. What's the issue with adding two store statements in the script??
Best,
Sunny
I have scenario where I want to place same qvd in three different environments i.e test,dev and prod, where I have to the same for 30 tables
John
I agree with sunny that this is not possible with a single STORE command.
You can run some command line copy actions from within the script using EXECUTE, if you prefer that over multiple STORE statements (this could also potentially call a multi file copy operation, like copying a complete folder at once).
you could do a loop for each location
set location1 = 'prod/Table.qvd';
set location2 = 'uat/Table.qvd';
set location3 = 'dev/Table.qvd';
for counter = 1 to 3
store Table into $(location)$(counter)(qvd);
next