Utility Statements › SYNCHRONIZE STAMPS › Sample Output

Sample Output

The following report sample is produced by the SYNCHRONIZE STAMPS utility.

IDMSBCF  nn.n                     CA IDMS Batch Command Facility                    mm/dd/yy                  PAGE 1
SYNCHRONIZE STAMPS FOR AREA USERDB.EMP_AREA COMPARE;
*+ Status = 0        SQLSTATE = 00000
                        *** Current Stamps Report ***
  Area:USERDB.EMP_AREA                        Table Stamping
      Catalog Stamp:  <null>

      Database Stamp: <null>

          Table ID:1024   Table:DEMO.EMPL
              Catalog Stamp:  1993-03-08-14.50.01.952955
              Database Stamp: 1993-03-08-14.50.01.952955

          Table ID:1025   Table:DEMO.POSITION
              Catalog Stamp:  1993-03-08-14.50.01.668147
              Database Stamp: 1993-03-08-14.50.01.668147

          Table ID:1026   Table:DEMO.MANAGERS
              Catalog Stamp:  1993-03-08-14.50.01.952955
              Database Stamp: 1993-03-08-14.50.01.952955

          Table ID:1027   Table:INV.PART
              Catalog Stamp:  1996-06-18-10.40.51.839925
              Database Stamp: 1996-06-18-10.40.51.839925

          Table ID:1028   Table:INV.COMPONENT
              Catalog Stamp:  1996-06-18-10.40.51.839925
              Database Stamp: 1996-06-18-10.40.51.839925

          Table ID:1029   Table:EMP.T5
              Catalog Stamp:  2001-11-05-09.31.31.638046
              Database Stamp: 2001-11-05-09.31.31.638046

          Table ID:1030   Table:LRD.EMPL
              Catalog Stamp:  2002-06-28-15.11.18.494317
              Database Stamp: 2002-06-28-15.11.18.494317

          Table ID:1031   Table:JPD.T5
              Catalog Stamp:  1999-06-21-13.04.08.968700
              Database Stamp: 1999-06-21-13.04.08.968700

Note: For more information about synchronization stamps, see the CA IDMS Database Administration Guide and the CA IDMS SQL Reference Guide.