Kbase P51132: How does the DataServer schema verify utility work?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/8/2004 |
|
Status: Verified
GOAL:
How does the DataServer schema verify utility work?
GOAL:
How does the DataServer schema verify utility check for consistency between DataServer schema and foreign database schema?
FACT(s) (Environment):
DataServers
FIX:
The DataServer Verify Utility, verifies Sequences, Tables, Fields, Indices, and Index Fields. The following is a list of Progress meta schema fields that are compared to the foreign data source system information. The differences are broken up into categories, Severe, Internal, Retainable, and Minor.
If the field being compared is unknown in the schema holder, then it will not be compared. If after gathering information from the foreign data source, the corresponding object cannot be found, then an error message is included for that also.
The information is for the ORACLE (ORA), MS SQL Server (MSS) and ODBC (ODBC) DataServers. If a check is for a specific DataServer, then it's Database type will be listed. If no Database type is listed the attribute is checked for all DataServers. This information is for Version 9.1D.
Sequences
· _Seq-name (Sequence Name)
Table - Severe
· _File._For-type (Foreign Type)
· _File._Fil-Misc2[1] ( Package-name) (ORA)
· Verifies that table exists in foreign data source
Table - Internal
· _File._Fil-Misc2[2] (Column number of _ident field) (MSS and
ODBC)
· _File._Fil-Misc2[3] (Name of Progress recid field) (MSS and ODBC)
· _File._Fil-Misc2[4] (Procedure parameter names) (MSS and ODBC)
· _File._Fil-Misc1[3] (First integer field found by name that does
not participate in an index) (MSS and ODBC)
Table - Retainable
· _File._File-name (Name in Progress)
· _File._Fil-Misc1[1] (Column offset number for the progress_recid
column)
· _File._Fil-Misc1[4] (Column that is a unique integer and can be
used as recid) (ORA)
· _File._Desc (Description of File)
Field - Severe
· _Field.Extent (Number of field that should be in foreign data
source)
· _Field._Fld-Misc2[2] (Offset for the field's corresponding shadow
column as character)(ORA)
· _Field._Fld-Misc2[5] (Shadow column name) (MSS and ODBC)
· _Field ._Fld-stoff ( Foreign offset)
· _Field ._Fld-Misc1[1] (Precision)
· _Field ._Fld-Misc1[2] (Scale)
· _Field ._Fld-Misc1[3] (Length)
· _Field ._Fld-Misc1[4] (Radix)
· _Field ._Fld-Misc1[5] (Shadow column number)
· _Field ._For-type (Foreign data type)
· _Field ._Fld-stdtype (Foreign data type number)
· _Field ._For-Itype (Parameter type for stored procedures)
· Verifies that all fields exist in foreign object
Field - Retainable
· _Field ._Fld-case (Case Sensitivity)
· _Field ._Mandatory (Null capable)
· _Field ._Field-name (Progress name)
· _Field ._Desc (Description)
· _Field ._Data-type (Progress data type being compatible with
foreign source data type)
· _Field ._Decimals (Decimals)
· _Field ._Format (Format)
Field - Internal - Minor
· Checks to see if the "time" field is present for "Date" fields in
schema holder (ORA)
Index - Internal
· _Index._Idx-num (Index number)
Index - Retainable
· _Index._Index-name (Progress Name)
· _Index._Unique (Uniqueness)
· _Index._Desc (Description)
· Verifies that the Primary index information is correct
Index - Minor
· _Index._Active (Active)
· _Index._I-Misc2[1] (Usability for ROWID index)
· Checks to see if all Indices in schema holder are in foreign data
source
Index Fields - Severe
· _Index-Field._Ascending (Ascending)
· _Index-Field._Index-Seq (Field order in index)
Index Fields - Minor
· _Index-Field._Abbreviate (Abbreviated)