ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA 7 Datacom database definition (Table and Column names)

book

Article ID: 212395

calendar_today

Updated On:

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.