Listing CONNECTION parameter of tables extending %Library.Persistent
I need to do an audit of Linked tables which are using a specific SQL Gateway connection, and there are many.
This is defined by the parameter CONNECTION contained within the table class which extends Extends %Library.Persistent
Is parameter exposed within a table somewhere?
Product version: IRIS 2024.1
$ZV: IRIS for Windows (x86-64) 2024.1.2 (Build 398U) Thu Oct 3 2024 14:01:59 EDT
Discussion (1)1
Comments
CONNECTION is a class parameter, to search all class parameters named CONNECTION with a specific value:
select parent from %Dictionary.CompiledParameter
where name = 'CONNECTION' and _Default='<your connection value to search>'