Skip to main content

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