Bulk update records

bgreene79

Hi there! I have started working with the IDO extension classes and am running into a performance issue. I have a couple of processes where I need to set or update a column for every record in a table (the items table). However, doing that through the IDO extension class takes forever since I have to loop through each record and do it one at a time, where I would be able to do all of them at once using SQL. Is there a method to do that where I don't have to loop through each record?

Thanks!

rcostello

You can call sql directly using CreateApplicationDB() this older post shows how to do it:

https://community.infor.com/discussion/11983/appdb-being-depricated-how-do-you-use-applicationdb?tab=accepted&utm_source=community-search&utm_medium=organic-search&utm_term=CreateApplicationDB