Using Toad for DB2 functionalities received the errors below i.e. alter a table and change the order of column:
A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=UTPRINT.
09:50.07 DSNUGUTC - LOAD DATA INDDN TOAD8 RESUME YES LOG NO WORKDDN(TOAD9, TOAD10) ERRDDN
TOAD11 MAPDDN TOAD13 DISCARDDN TOAD12
DSNU650I -DT1C 062 19:09:50.08 DSNURWI - INTO TABLE("B017119"."Y2KTEST3") IGNOREFIELDS YES WHEN(1:2=X'0003')
DSNU650I -DT1C 062 19:09:50.08 DSNURWI - (HEADER_RSVRD POSITION(*) CHAR(2),
DSNU650I -DT1C 062 19:09:50.08 DSNURWI - "B" POSITION(*) DEC EXTERNAL(10, 0),
DSNU650I -DT1C 062 19:09:50.08 DSNURWI - "A" POSITION(*) CHAR(5))
DSNU320I -DT1C 062 19:09:50.15 DSNURWI - RESUME(YES) WAS SPECIFIED FOR EMPTY TABLESPACE
DSNU1038I 062 19:09:50.18 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD8
DDNAME=SYS00007
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707142.U
DSNU1038I 062 19:09:50.27 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD9
DDNAME=SYS00008
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707148.I
DSNU1038I 062 19:09:50.30 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD10
DDNAME=SYS00009
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707142.O
DSNU1038I 062 19:09:50.32 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD12
DDNAME=SYS00010
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707144.D
DSNU1038I 062 19:09:50.34 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD11
DDNAME=SYS00011
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707148.ER
DSNU1038I 062 19:09:50.36 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=TOAD13
DDNAME=SYS00012
DSN=Z.STG.B017119.DB017119.Y2KTEST3.T0707149.MAP
DSNU304I -DT1C 062 19:09:50.53 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=9 FOR TABLE B017119.Y2KTEST3
DSNU1147I -DT1C 062 19:09:50.53 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=9 FOR TABLESPACE
DB017119.Y2KTEST3
DSNU302I 062 19:09:50.54 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=9
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center