DB2 and SQL Dataview names in Datadictionary

Products

• Datacom
• DATACOM - AD
• Ideal
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

This article will explain the syntax for DB2 and SQL Dataview names in Datadictionary

Environment

Release: Ideal for Datacom

Resolution

In 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 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 Datadictionary, the occurrence names of SQL dataviews contain a percent sign (%) instead of a period. The Datadictionary occurrence name for the Ideal dataview SYSUSR.PAYROLL would be SYSUSR%PAYROLL.