CA 7 Datacom database definition (Table and Column names)

Products

• CA 7 Workload Automation

Issue/Introduction

I would like to use SQL to extract data from the CA 7 database. How can I find a list of all the table names and columns in the CA 7 database?

 

 

Environment

Release : 12.0, 12.1

Component : CA-7

Resolution

Member AL2SQLD is provided in the CAL2OPTN installation library. The AL2SQLD member contains the CA 7 SQL table definitions.