I am planning to delete records from more than 1 partitions in a table using the DB2 load utility.
I have used :
LOAD DATA RESUME(YES) ENFORCE CONSTRAINTS
INDDN(SYSRECAC) INTO TABLE IXY1.MAIN_ITM PART 2 REPLACE
where SYRECAC contains an empty file
to delete records from second partition and it works successfully.
Do we have LOAD commands to delete from a range of partitions- say partitions 2 to 4 or 1 to 2.
I have tried
LOAD DATA INDDN(SYSRECAC)
INTO TABLE IXY1.MAIN_ITM REPLACE PART 1:2
but I get error messages like INVALID OPERAND '2' FOR KEYWORD 'INTO' .