Hi All -
The objective is to move transactions to a history table and this is my code:
For each order no-lock:
status default "Moving Orders to History.." + string(order.order-no) + ".." + string(order.order-date).
create order-hist.
assign order-hist.entity = order.entity
order-hist.order-no = order.order-no
order-hist.order-date = order.orer-date
(more fields) .
End.
After a few records, I get the error 'Lock table Overflow. Increase -L on server".
In the DB startup script the -L is 10000 and -l is 1000.
What's the solution? Is it possible to put the create statement inside a transaction of 100 and then exit out and come back in to do another 100?
Thanks in advance for your help !
The objective is to move transactions to a history table and this is my code:
For each order no-lock:
status default "Moving Orders to History.." + string(order.order-no) + ".." + string(order.order-date).
create order-hist.
assign order-hist.entity = order.entity
order-hist.order-no = order.order-no
order-hist.order-date = order.orer-date
(more fields) .
End.
After a few records, I get the error 'Lock table Overflow. Increase -L on server".
In the DB startup script the -L is 10000 and -l is 1000.
What's the solution? Is it possible to put the create statement inside a transaction of 100 and then exit out and come back in to do another 100?
Thanks in advance for your help !