DB2 and SQL Dataview names in CA Datadictionary

Document ID : KB000055197
Last Modified Date : 14/02/2018
Show Technical Document Details

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.