I'm working on a new Access Definition which will execute an Archive Action to invoke a stored procedure housed in a different DB Alias than the tables being archived in the AD.
Is there a way to override the value of the DB Alias used in the archive action if it differs from the Default DB Alias??
We override the Default DB Alias all the time as this allows use to use a single AD across various environments. However, if we can't override the DB Alias used in the Archive Action, then we will need to create separate versions of the same AD in each environment, which is fairly annoying.
I have a feeling we can't override this DB Alias used for the Archive Action, but maybe there is something I'm missing? We are using Optim v11.3.8 on Windows.
Appreciate the help!
-Keith
------------------------------
Keith Tidball
Progressive Insurance
------------------------------