Utility Statements › LOAD › Sample Output

Sample Output

Complete LOAD

The following report was generated after executing the LOAD statement in example 1 shown previously.

IDMSBCF                                              IDMS Batch Command Facility

CONNECT TO SYSCAT;
Status = 0
SET BATCH
    HEADINGS OFF WIDTH PAGE 79 UNDERLINE '-'
    SQLCODE ERROR
    COMPRESS ON;
*DEBUG IDMS OFF

--   ****  FORMAT segments      ****

FORMAT SEGMENT USERDB;

File USERDB.EMPF1                blocks 1 to 50.
Area USERDB.EMP_AREA             pages 5,001 to 5,050.
Page size in file 4,096.

File USERDB.ORGF1                blocks 1 to 50.
Area USERDB.ORG_AREA             pages 5,051 to 5,100.
Page size in file 4,096.

File USERDB.EMPIX                blocks 1 to 50.
Area USERDB.EMPIX_AREA           pages 5,101 to 5,150.
Page size in file 2,000.
--   ****  Load data into Tables      ****

*DEBUG IDMS ON

LOAD INTO LOAD.A    WHERE POSITION 60 = 'A'

     INTO LOAD.B    WHERE POSITION 60 = 'B'

     INTO LOAD.H    WHERE POSITION 60 = 'H'

   NO VALIDATE     LRECL 80;
IDMSLOAD  -   volser     PRESORT TABLES FOR LOAD     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  1 records processed for table LOAD.H
IDMSLOAD  -  1 records processed for table LOAD.B
IDMSLOAD  -  1 records processed for table LOAD.A
IDMSLOAD  -  7 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 136 characters
IDMSLOAD  -         PRESORT TABLES FOR LOAD     processing completed
IDMSLOAD  -   volser     LOAD TABLES AFTER SORT     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  1 records processed for table LOAD.A
IDMSLOAD  -  1 records processed for table LOAD.B
IDMSLOAD  -  1 intermediate records for constraint LOAD.PKIX_B
IDMSLOAD  -  1 intermediate records for constraint LOAD.FKIX_B
IDMSLOAD  -  1 intermediate records for constraint LOAD.AB_S2
IDMSLOAD  -  1 records processed for table LOAD.H
IDMSLOAD  -  1 intermediate records for constraint LOAD.PKIX_H
IDMSLOAD  -  3 records were stored in the database
IDMSLOAD  -  12 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         LOAD TABLES AFTER SORT     processing completed
IDMSLOAD  -   volser     FILL IN OWNERS DBKEY     yy-mm-dd-hh.mm.ss

IDMSLOAD  -  12 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         FILL IN OWNERS DBKEY     processing completed
IDMSLOAD  -   volser     CONNECT UP INDEXES     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  9 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         CONNECT UP INDEXES     processing completed
IDMSLOAD  -   volser     BUILD RECORD PREFIX     yy-mm-dd-hh.mm.ss
IDMSLOAD  -         BUILD RECORD PREFIX     processing completed


AutoCommit will COMMIT transaction

Command Facility ended with warnings

Complete LOAD specifying column name

The next report was generated after executing the LOAD statement in example 2.

Note: Some errors occurred during the load of tables LOAD.M and LOAD.M2. The LOAD utility provides useful information about the type and location of the error. Additional status information can be found in the CA IDMS Messages and Codes Guide.

IDMSBCF                                              IDMS Batch Command Facility

*DEBUG IDMS OFF
CONNECT TO SYSCAT;
Status = 0
SET BATCH
    HEADINGS OFF WIDTH PAGE 79 UNDERLINE '-'
    SQLCODE ERROR
    COMPRESS ON;


--   ****  Load data into Tables      ****
*DEBUG IDMS ON

LOAD INTO LOAD.C    WHERE POSITION 60 = 'C'

     INTO LOAD.D    WHERE POSITION 60 = 'D'

     INTO LOAD.E    WHERE POSITION 60 = 'E'

     INTO LOAD.F    WHERE POSITION 60 = 'F'

     INTO LOAD.G    WHERE POSITION 60 = 'G'

     INTO LOAD.M WHERE MCHAR = 'M1'
   (MCHAR    POSITION 1   CHAR(2),
    MVCHAR   POSITION 3   VARCHAR,
    MBIN     POSITION 7   BINARY(2),
    MHALF    POSITION 9   SMALLINT,
    MFULL    POSITION 11  INTEGER,
    MLONG    POSITION 15  LONGINT,
    MDEC     POSITION 23  DEC(2,1),
    MDECU    POSITION 25  UNSIGNED DEC(3,3),
    MNUM     POSITION 27  NUM(2,1),
    MNUMU    POSITION 29  UNSIGNED NUMERIC(3,3),
    MDATE    POSITION 32  DATE,
    MTIME    POSITION 42  TIME,
    MTS      POSITION 50  TIMESTAMP
    )

     INTO LOAD.M2 WHERE POSITION 1 = 'M2'
   (MGRAPH   POSITION 3   GRAPHIC,
    MVGRAPH  POSITION 5   VARGRAPHIC(4),
    MREAL    POSITION 15  REAL,
    MFLOAT1  POSITION 19  FLOAT(4),
    MFLOAT2  POSITION 23  FLOAT(50),
    MDP      POSITION 31  DOUBLE PRECISION
    )
     ERRORS CONTINUE
         LRECL 80;
IDMSLOAD  -   volser     PRESORT TABLES FOR LOAD     yy-mm-dd-hh.mm.ss
SQLCODE = -4__     Extended reason code = 1026     Messages follow:
DB001026 C-4M322: Data conversion error
IDMSLOAD  -  error in table LOAD.M  -  I/P record sequence number 10
IDMSLOAD  -  error in column 32  -  column name is MDATE
ERROR RECORD -─►   +0     D4F10001 C2F1FFFF 00020000 00020000 M1..B1..........
                   +10    00000000 0002022C 022FF2C2 F0F2F2E7 ..........2B022X
                   +20    E7E7E760 E7E760E7 E7E7E74B F3F04BF0 XXX-XX-XXXX.30.0
                   +30    F1F1F3F9 F060F0F1 60F0F260 F1F64BF3 11390-01-02-16.3
                   +40    F04BF0F1 4BF0F0F0 F0F040            0.01.00000
SQLCODE = -4       Extended reason code = 1025     Messages follow:
DB001025 C-4M322: Data exception
IDMSLOAD  -  error in table LOAD.M2  -  I/P record sequence number 16
IDMSLOAD  -  error in column 5  -  column name is MVGRAPH
ERROR RECORD -─►   +0     D4F2C7F4 0004C7F1 C7F2C7C7 C7C70000 M2G4..G1G2GGGG..
                   +10    00000000 00000000 00000000 00000000 ................
                   +20    00000000 0000                       ......
IDMSLOAD  -  3 records processed for table LOAD.M2
IDMSLOAD  -  3 records processed for table LOAD.M
IDMSLOAD  -  1 records processed for table LOAD.G
IDMSLOAD  -  1 records processed for table LOAD.F
IDMSLOAD  -  1 records processed for table LOAD.E
IDMSLOAD  -  1 records processed for table LOAD.D
IDMSLOAD  -  1 records processed for table LOAD.C
IDMSLOAD  -  19 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 136 characters
IDMSLOAD  -         PRESORT TABLES FOR LOAD     processing completed
IDMSLOAD  -   volser     LOAD TABLES AFTER SORT     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  1 records processed for table LOAD.C
IDMSLOAD  -  1 intermediate records for constraint LOAD.FKIX_C
IDMSLOAD  -  1 intermediate records for constraint LOAD.BC_S2
IDMSLOAD  -  1 records processed for table LOAD.D
IDMSLOAD  -  1 intermediate records for constraint LOAD.PKIX_D
IDMSLOAD  -  1 intermediate records for constraint LOAD.FKIX_D
IDMSLOAD  -  1 records processed for table LOAD.E
IDMSLOAD  -  1 intermediate records for constraint LOAD.PKIX_E
IDMSLOAD  -  1 records processed for table LOAD.F
IDMSLOAD  -  1 intermediate records for constraint LOAD.FKIX_F
IDMSLOAD  -  1 intermediate records for constraint LOAD.FKIX_FB
IDMSLOAD  -  1 records processed for table LOAD.G
IDMSLOAD  -  3 records processed for table LOAD.M
IDMSLOAD  -  3 intermediate records for constraint LOAD.IX_M
IDMSLOAD  -  3 records processed for table LOAD.M2
IDMSLOAD  -  3 intermediate records for constraint LOAD.IX1_M2
IDMSLOAD  -  3 intermediate records for constraint LOAD.IX2_M2
IDMSLOAD  -  11 records were stored in the database
IDMSLOAD  -  34 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         LOAD TABLES AFTER SORT     processing completed
IDMSLOAD  -   volser     FILL IN OWNERS DBKEY     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  34 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         FILL IN OWNERS DBKEY     processing completed
IDMSLOAD  -   volser     CONNECT UP INDEXES     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  19 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         CONNECT UP INDEXES     processing completed
IDMSLOAD  -   volser     BUILD RECORD PREFIX     yy-mm-dd-hh.mm.ss
IDMSLOAD  -         BUILD RECORD PREFIX     processing completed
IDMSLOAD  -   volser     VALIDATE INDEXES STEP 1     yy-mm-dd-hh.mm.ss
IDMSLOAD  -  1 records processed for table LOAD.C
IDMSLOAD  -  0 intermediate records for constraint LOAD.BC_S1
IDMSLOAD  -  0 intermediate records for constraint LOAD.BC_S2
IDMSLOAD  -  0 intermediate records for constraint LOAD.BC_S3
IDMSLOAD  -  1 records processed for table LOAD.D
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_DD
IDMSLOAD  -  1 intermediate records for constraint LOAD.LOAD_AD
IDMSLOAD  -  2 records processed for table LOAD.E
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_AE
IDMSLOAD  -  0 records processed for table LOAD.F
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_EF
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_BF
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_HF
IDMSLOAD  -  1 records processed for table LOAD.G
IDMSLOAD  -  0 intermediate records for constraint LOAD.LOAD_BG
IDMSLOAD  -  0 records processed for table LOAD.M
IDMSLOAD  -  0 records processed for table LOAD.M2
IDMSLOAD  -  19 intermediate records were written to SYS003
IDMSLOAD  -       largest SYS003 record size is 56 characters
IDMSLOAD  -         VALIDATE INDEXES STEP 1     processing completed
IDMSLOAD  -   volser     VALIDATE INDEXES STEP 2     yy-mm-dd-hh.mm.ss
IDMSLOAD  -         VALIDATE INDEXES STEP 2     processing completed
Status = 1        Extended Reason Code = 2991     Messages follow:
DB002991 C1M349: Error detected doing a LOAD/BUILD/VALIDATE statement

AutoCommit will COMMIT transaction

Command Facility ended with warnings