Listing CONNECTION parameter of tables extending %Library.Persistent |

Question

Andy Stobirski · Dec 11, 2024

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

Enrico Parisi · Dec 11, 2024

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>'

1 0