List attributes of SQL, SAP, and Rapid Automation connection objects

[Michael A. Lowry]

Connection object attributes differ by type. It can be useful to list the available attributes by connection object type. Here is an SQL query that will do this.

SELECT ONA.ONA_HostAttrType,ONA.ONA_JOBTYPE,ONA.ONA_SUBTYPE, OCV.OCV_VName, MIN(DBMS_LOB.substr(OCV_VALUE,256,1))
FROM OCV
INNER JOIN OH ON OCV.OCV_OH_IDNR = OH_IDNr
INNER JOIN ONA ON OH_Idnr=ONA_OH_Idnr
WHERE OH_DeleteFlag = '0'
AND OH_Idnr > 100000
GROUP BY ONA.ONA_HostAttrType,ONA.ONA_JOBTYPE,ONA.ONA_SUBTYPE, OCV.OCV_VName
ORDER BY ONA.ONA_HostAttrType,ONA.ONA_JOBTYPE,ONA.ONA_SUBTYPE, OCV.OCV_VName

Enjoy.