DB2 and SQL Dataview names in CA Datadictionary

Products

• Datacom
• DATACOM - AD
• Ideal
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

In CA Ideal, the names of dataviews for SQL access (DB2 or Datacom) are composed of an authorization-ID, a period (.) and the SQL object name (table, view or CA Datacom SQL synonym.) The name of the SQL dataview related to the table PAYROLL where SYSUSR is the related authorization-ID would be SYSUSR.PAYROLL.

The period is a syntactical delimiter for Datadictionary commands, and cannot be part of an occurrence name. For this reason, in CA Datadictionary, the occurrence names of SQL dataviews contain a percent sign (%) instead of a period. The CA Datadictionary occurrence name for the Ideal dataview SYSUSR.PAYROLL would be SYSUSR%PAYROLL.

Environment

Release:
Component: IDEAL