Previous Topic: Set Errors -- After Image ReportNext Topic: Integrated Index Pointer Errors


Set Disconnections

An example of a record that was fully disconnected from a set is shown in Figures 4.14a and 4.14b. Records displayed on this section of the report are grouped by set name, and are members of either a mandatory automatic or a DISCONNECT set.

Here is a description of the fields that make up the Before Image Report.

Lines 1 thru 5 - Before Image Report header.

Line 6 - Informative message--indicates the set name where record was disconnected.

RECORD NAME - Name of the record.

ID - Record identifier.

DBKEY - Db-key of the database record.

RECORD DATA - First 88 characters of data.

CA-TOOLS                  RELEASE                     CA IDMS/DB AUDIT       DATE               TIME            PAGE                            Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0004  *********************************************************************************************************************  ************************************************  B E F O R E   I M A G E  ******************************************  *********************************************************************************************************************  xxxx032I RECORDS FULLY DISCONNECTED FROM SET...STUDENT-REPORTS      ---RECORD NAME-- -ID-  --DBKEY---      -------------------------------RECORD DATA--------------------------------      GREPORT          8109  91,002-028      120280    MA1019500002EXCELLENT STUDEN

Figure 4.14a: Set Disconnections

CA-TOOLS                  RELEASE                     CA IDMS/DB AUDIT       DATE               TIME            PAGE                            Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0001  *********************************************************************************************************************  ************************************************  B E F O R E   I M A G E  ******************************************  *********************************************************************************************************************  xxxx032I RECORDS FULLY DISCONNECTED FROM SET...DEPT-TEACHER      ---RECORD NAME-- -ID-  --DBKEY---      -------------------------------RECORD DATA--------------------------------      TEACHER          1001 88,002-0002       00008JOHN             SAMPLER        ANY             BS      TEACHER          1001 88,002-0003       00010JOE              SAMPLER        ANY             BS      TEACHER          1001 88,002-0004       00015BRUCE            BEEKER         ANY             BS      TEACHER          1001 88,002-0005       00017JOAN             HADLY          ANY             BS      TEACHER          1001 88,002-0006       00024MARK             DUDD           ANY             BS      TEACHER          1001 88,003-0004       00012TOM              SAMPLER        ANY             BS      TEACHER          1001 88,004-0002       00021JILL             HENNY          ANY             BS      TEACHER          1001 88,011-0003       00013ARTHUR           SAMPLER        ANY             BS      TEACHER          1001 88,011-0004       00014DON              BELTMAN        ANY             BS      TEACHER          1001 88,011-0005       00018PAT              HENRY          ANY             BS      TEACHER          1001 88,011-0006       00019JOE              ENDRIK         ANY             BS      TEACHER          1001 88,012-0003       00009JEAN             SAMPLER        ANY             BS      TEACHER          1001 88,012-0004       00022JOHN             DRICK          ANY             BS      TEACHER          1001 88,012-0005       00023GARY             RICKS          ANY             BS      TEACHER          1001 88,014-0001       00011MIKE             SAMPLER        ANY             BS      TEACHER          1001 88,014-0002       00016KAREN            GAVIN          ANY             BS      TEACHER          1001 88,015-0003       00020JIM              KINK           ANY             BS

Figure 4.14b: Set Disconnections