CREATE TABLE T_OFED_JOB (
    OFED_JOB_ID   D_INTKEY /* D_INTKEY = INTEGER NOT NULL */,
    OFED_JOBKOD   D_VARCHAR50 NOT NULL /* D_VARCHAR50 = VARCHAR(50) */,
    OFED_JOBNAME  D_VARCHAR_255 NOT NULL /* D_VARCHAR_255 = VARCHAR(255) */,
    OKPDTR        D_VARCHAR50 /* D_VARCHAR50 = VARCHAR(50) */,
    DATE_IN       D_DATE /* D_DATE = DATE */,
    OFED_DEP_ID   D_INTEGER /* D_INTEGER = INTEGER */
);


ALTER TABLE T_OFED_JOB ADD CONSTRAINT PK_T_OFED_JOB PRIMARY KEY (OFED_JOB_ID);

select * from T_OFED_JOB 

select * from T_OFED_JOB order by OFED_JOB_ID  

select * from T_OFED_JOB order by OFED_JOB_ID + 0;
select count(*) from T_OFED_JOB ; 
select count(*) from T_OFED_JOB order by OFED_JOB_ID ;
select count(*) from T_OFED_JOB order by OFED_JOB_ID + 0 ;

IDK (Server)	Tue Feb 19 16:21:20 2019
	Database: IS_IDK
	Index 1 is corrupt (missing entries) in table T_OFED_JOB (196)

IDK (Server)	Tue Feb 19 16:21:22 2019
	Database: IS_IDK
	Relation has 484 orphan backversions (0 in use) in table F_IDK (209)

violation of PRIMARY or UNIQUE KEY constraint "PK_T_OFED_JOB" on table "T_OFED_JOB".
Problematic key value is ("OFED_JOB_ID" = 3570).

delete from T_OFED_JOB where t_ofed_job.OFED_JOB_ID = 3570

185 records deleted

backup/restore 

IBE: Validation completed, no errors found

CREATE GENERATOR GEN_T_OFED_JOB_ID;

CREATE TABLE T_OFED_JOB (
    OFED_JOB_ID   D_INTKEY /* D_INTKEY = INTEGER NOT NULL */,
    OFED_JOBKOD   D_VARCHAR50 NOT NULL /* D_VARCHAR50 = VARCHAR(50) */,
    OFED_JOBNAME  D_VARCHAR_255 NOT NULL /* D_VARCHAR_255 = VARCHAR(255) */,
    OKPDTR        D_VARCHAR50 /* D_VARCHAR50 = VARCHAR(50) */,
    DATE_IN       D_DATE /* D_DATE = DATE */,
    OFED_DEP_ID   D_INTEGER /* D_INTEGER = INTEGER */
);

ALTER TABLE T_OFED_JOB ADD CONSTRAINT PK_T_OFED_JOB PRIMARY KEY (OFED_JOB_ID);

/* Trigger: T_OFED_JOB_BI */
CREATE OR ALTER TRIGGER T_OFED_JOB_BI FOR T_OFED_JOB
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.ofed_job_id is null) then
    new.ofed_job_id = gen_id(gen_t_ofed_job_id,1);
enв

    update or insert into t_ofed_job
    (
    OFED_jobKOD,
    OKPDTR,
    OFED_jobNAME,
    ofed_dep_id
    )
    values (
      :jobKOD,
      :okpdtr,
      :jobNAME,
      :OFED_DEP_ID
    )
    matching (
      OFED_jobKOD,
      OKPDTR,
      OFED_jobNAME,
      ofed_dep_id
    )