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

WA CA 7 Edition

Resolution

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