Re: SQL Insert I need a line#/seq#

This was all done using run sql scripts:
values current schema;

create sequence styhs2r
start with 1
increment by 1
no maxvalue
no cycle;

drop table rob.wkusum99;
create rob.wkusum99 as (
select
cast(0 as smallint) as myseq#, ili.*
from erplxf.ili ili
) with no data;

select lprod, count(*)
from erplxf.ili
group by lprod
having count(lprod) > 1;

alter sequence rob.styhs2r
restart;

insert into rob.wkusum99
(select next value for rob.styhs2r, ili.*
from erplxf.ili ili
where lprod='225326.1.1');

select * from wkusum99;

The final select showed me 8 rows

Rob Berendt