Question Mark OReilly · 5 hr ago Create a local copy of a linked table As foreign tables are behind a paywall (booo); we have a external cache system using the intersystems ODBC driver or usually a .jar CacheDB.jar. The requirement is : "Create a copy of the external table once a day to perform comparisons to detect changes" We could go full code and this is what we will do but trying the following should ideally work #SQL #InterSystems IRIS for Health #Health Connect 0 0 0 9