A partitioned DB2 table is defined as follows:
CREATE TABLESPACE TSTBP1;
CREATE TABLESPACE TSTBP2;
CREATE TABLE TABPART1 (
CHAR01 CHAR(4) NOT NULL ,
PACK01 DECIMAL(3,0) NOT NULL ,
CHAR02 CHAR(2) NOT NULL )
PARTITION BY RANGE(CHAR01)
(PART 1 STARTING(MINVALUE) ENDING('LLLL') IN TSTBP1,
PART 2 ENDING('ZZZZ') IN TSTBP2)
ORGANIZE BY ROW ;
GRANT CONTROL ON TABLE TABPART1 TO PUBLIC;
When loading data into "PART 1", the record being loaded should be rejected, as per the STARTING and ENDING configuration, because the sample record contains "TTTT"
The JCL/JOB fails with the following error :
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = DSNTEX
DSNU050I DSNUGUTC - LOAD DATA INDDN(SYSREC)
DSNU650I DSNUUGMS - INTO TABLE TABPART1 PART 1 REPLACE
DSNU650I DSNUUGMS - ( "CHAR01"
DSNU650I DSNUUGMS - POSITION( 00001:00004) CHAR(00004)
DSNU650I DSNUUGMS - , "PACK01"
DSNU650I DSNUUGMS - POSITION( 00005:00006) DECIMAL
DSNU650I DSNUUGMS - , "CHAR02"
DSNU650I DSNUUGMS - POSITION( 00007:00008) CHAR(00002)
DSNU650I DSNUUGMS - )
MBDT0002 - SQLCODE: -206, SQLSTATE: S0022 - SQL0206N "MINVALUE" is not valid in the context where it is used. S
MBDT0002 - Error removing data from DB2INST1.TABPART1 Partition 1
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
***END OF FILE***
Full article: https://portal.microfocus.com/s/article/KM000015887
#EnterpriseDeveloper
#SupportTips/KnowledgeDocs