Re: Trigger pgm to increment seq# in file

Getting the order# to work via identity column, or sequence object, is a
snap.

However, incrementing the order line number where you can a duplicate line
number, but not a duplicate order/line combo, is a little different. This
will take some logic like

select ifnull(max(orderline), 0) + 1
from ordline
where ordernumber = :myOrderNumber;

The ifnull covers adding the first line.

Personally I find this easier than some sort of READ or READP permutations
to determine the next available line number.


Rob Berendt