Chris Muldrow wrote at 2003-2-21 14:03 -0500:

I've got some old ZSQL methods floating around somewhere that are hooked to an old Database connector (ZODBCDA) that we aren't using anymore. I was trying to get a catalog to find all of the SQL methods so I can throw the old ones away, but I can't figure out how to pull out the value of the connection_id into the catalog. Is there a way to do this ("Find all ZSQLMethods where connection_id="broken")?

The connection id is shown in the ZMI (Z SQM Method "Edit" tab), right? Look at its source and learn how it accesses the connection_id. You may not be able to find them directly with a catalog query. You may need to filter with a Python Script. Dieter