I have a program reading data from a JSON response. The data is initially read into temp-tables and after the JSON has been successfully processed I copy the temp-table data to the database. One of the temp-tables sometimes is getting 7,600+ rows of data which causes the copy from temp-table to database to get the error 'Lock table overflow, increase -L on server (915)'. I tried to use the RELEASE stmt in the for each each loop but that did not help. How can I resolve this without changing my startup parameters? I don't have any control over number of rows that can be passed in JSON response.
My current code looks as follows
My current code looks as follows
Code:
define temp-table ttproducts like products.
/* RUN CODE TO READ JSON DATA TO TEMP-TABLE */
for each ttproducts:
create products.
buffer-copy ttproducts to products.
release products.
end.
/* Error looks to occur during processing of 'For each ttHAPIproducts above' */