How to do version upgrade when tables has dependency on custom UDx
I had few flex tables disappear after version upgrade.
After quite a lot of digging, it was traced to custom UDx library upgrade.
Users had flex tables that materialised column based on function from custom UDx library.
Those tables had dependency on custom UDx library.
On version upgrade, I had to recreate UDx library, linked with new version of UDx API.
I am issuing "drop library cascade", and it drops all tables that dependent on it.
I am a little bit lost, how I can do version upgrade, while keeping flex tables in place, and upgrading custom UDx library?
Version upgrade require custom UDx library upgrade, to use new UDx API. Library upgrade require "drop library cascade". Drop library drop all functions from library. That will drop dependent flex tables that uses functions.
How to keep flex tables from being dropped?
Your help is always appreciated.