create cursor xx ; ( dupkey c(4), ; codex c(2), ; copyno c(32) ; ) insert into xx values ('abcd', '12', 'Copy No 421') insert into xx values ('bbcd', '12', 'Copy No 421') insert into xx values ('cbcd', '12', 'Copy No 421') insert into xx values ('cbcd', '12', 'Copy No 422') index on bitnot(cast(dupkey+codex as blob)) + copyno tag xx