I have a VDS which is running a rather long query. I want to use reflection to store those results, but at the same time I want to be able to update the results.
How can I do that?
There seems to be no option to refresh a VDS through an sql command. At the same time I see no option to set a refresh schedule (like for a PDS reflection).
I tried updating the metadata of all the datasources that are being used in the query (with ALTER PDS … REFRESH METADATA FORCE UPDATE’), but that doesn’t trigger a reflection update either.
Any help would be appreciated.