[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Corticon 5.7.2.8 Batch Write

[Harold-Jan Verlee]

Hi Branden, Your batch read query fetches records one by one and seeds it to the decision service. You'd better use an IN statement there too: select detail_record_id from cms.cms_efd WHERE earnings_file_id IN ( {CmsEfd.earningsFileId} ) . That way, the batch will process a chunked number of records and will allow to write back to the DB with all its records in memory in one single pass (defined in your batch properties). Hope this helps. Regards, Harold

Continue reading...