RE: How to increment a ID field that is not a ID field.

CREATE TABLE rob.target_file
(
id INTEGER NOT NULL,
field1 char(10),
field2 char(10)
);

insert into rob.target_file values(1, 'a', 'a');
insert into rob.target_file values(2, 'a', 'a');
insert into rob.target_file values(3, 'a', 'a');

CREATE OR REPLACE SEQUENCE rob.seq1
START WITH 1
INCREMENT BY 1;

-- "prepare" this statement
alter sequence rob.seq1 restart with ##;
-- replacing ## with the number you got with
select max(id) + 1 from rob.target_file
;
insert into rob.target_file
values(next value for rob.seq1, 'a', 'a');

Rob Berendt