CREATE TABLE LETD.TrainList(
    TrainID        INT NOT NULL REFERENCES LETD.Train(ID),
    VagNo        CHAR( 8 ) NOT NULL REFERENCES LETD.Vagon(No),
    Weight        INT WITH DEFAULT,
    InTransfer    CHAR CHECK( InTransfer IN ('Y','N')),
    stAttach    INT,
    stDetach    INT,
    stDest        INT
);

CREATE TABLE LETD.TrainList(
    TrainID     INTEGER NOT NULL,
    VagNo       CHAR( 8 ) NOT NULL,
    Weight      INT WITH DEFAULT,
    InTransfer  CHAR CHECK (InTransfer IN ('Y','N')),
    stAttach    INTEGER WITH DEFAULT NULL,
    stDetach    INTEGER WITH DEFAULT NULL,
    stDest      INTEGER WITH DEFAULT NULL
)
PARTITION BY (mod(TRAINID, 10 ))
( PARTITION  1  ENDING AT ( 0 ),
 PARTITION  2  ENDING AT ( 1 ),
 PARTITION  3  ENDING AT ( 2 ),
 PARTITION  4  ENDING AT ( 3 ),
 PARTITION  5  ENDING AT ( 4 ),
 PARTITION  6  ENDING AT ( 5 ),
 PARTITION  7  ENDING AT ( 6 ),
 PARTITION  8  ENDING AT ( 7 ),
 PARTITION  9  ENDING AT ( 8 ),
 PARTITION  10  ENDING AT ( 9 ))
IN LETDDB01.LETDTS49
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      UNICODE
    NOT VOLATILE;