I have a HALDB Databse that has 84 partitions with key record as YYMMXXXXXXXXXXXXX. it also has a secondary index.
Partitions are based on YYMM varying from 0000 to 0612. X is a alphanumeric .
I wish to delete everything residing in a particular partition say 0301. In my program i issue a qualified SSA with GHN using PCB of primary index. SSA is defined on partial index with value varying from 0301x'0000000000000' to 0301x'FFFFFFFFFFFFF'. This is to have all records which falls under this range in 0301 partition.
After this GHN i issue a DLET call and later on I issue a unqualified GHN to get next record in database. this is followed by DLET call.
This process is repeated untill I find a record with different partition number.
Now the problem I'm facing is with the first qualified GHN call. It seems that call does not point to first record from 0301 partition, as once the job was complete, i could still see records from 0301 partition.
Could you please let me know how can I get first record from the partition?
just a philosophical/general remark...
if You delete all the database records within a certain key range x'0301zzz' ( x'00...00' <= zzz <= x'ff..ff' )
the partition where they reside should be irrelevant to the process
and finding some of them after the <delete> is just a symptom of some glitch in the process