The report workbook has the following worksheets. The worksheets display the details for the data present in the catalog and site databases.
Worksheet Name |
Database |
Type of Data Reported |
---|---|---|
Index |
General information |
Displays information about the server, databases, computer, and user name. |
CDB_Attributes |
Catalog database |
Displays attributes exceeding 30 characters. |
CDB_CustomInterfaces |
Catalog database |
Displays custom interfaces exceeding 30 characters. |
CDB_PartClasses |
Catalog database |
Displays part class names that are prone to fail when you generate views. This worksheet reports names that exceed 23 characters. |
SDB_Attributes |
Site database |
Displays attributes exceeding 30 characters. |
SDB_CustomInterfaces |
Site database |
Displays custom interfaces exceeding 30 characters. |
Because the data in the model database is a subset of the catalog database, the utility generates the report by querying only the catalog database. During the updating phase, Schema Name Validator checks for occurrences in all of the model databases under the catalog and updates them accordingly.
These workbooks follow the same format as bulkload data files. The keywords are the same with the addition of Data Base Info.
The keywords are not case-sensitive. They are space-sensitive, however. Do not add or remove spaces.
Keyword |
Significance |
Notes |
---|---|---|
Data Base Info |
Displays the selected catalog on catalog sheets and the selected site on site sheets. |
Do not edit this keyword. For example DataBaseInfo is not supported. |
Start |
Schema Name Validator reads only the values between the Start and End key words for the columns defined in the Head row. |
PackageName, Truncated Names, Attributes, CustomInterfaces, and PartClasses are standard columns. The utility does not recognize any additional columns. |
End |
Schema Name Validator does not process any values after the End keyword. |
|
! |
Indicates a comment row. If !Schema Name Validator reads ! between the Head and End keywords, it skips that row. |
Attributes
Specifies the attributes of custom interfaces.
PackageName
Indicates the package to which the value is associated. By default, every value belongs to a user-defined package (UDP).Because the system-defined data is corrected and delivered with Smart 3D, the software only considers custom data when looking for Oracle naming constraints. Because of this, every value under the PackageName column is UDP.
Truncated Names
Indicates the shortened name to use as a replacement for the name that exceeds the Oracle limit.
Custom interfaces and attributes must be 30 characters or fewer.
Part class names must be 23 characters or fewer because those names use the package name as a prefix and the view type as a suffix for view creation. For example, if BPS_5S_LapSup1Sup2Sup3Sup4 is the part class name, you would expect the following:
CUSSBPS_5S_LapSup1Sup2Sup3Sup4O
CUSSBPS_5S_LapSup1Sup2Sup3Sup4OV