Multithreaded SQL requests

Hi,

An RPGLE currently invokes many embedded SQL requests consecutively via an "execute immediate" statement.
The impact is not significant when the RPGLE is run as a discrete standalone request but mounts up when performed during a batch job of several 100 thousand bulk requests.
I was thinking of using RPGLE multi-threading APIs to run the SQL requests within an RPGLE sub-procedure so that they could execute simultaneously.
However I thought I read somewhere that multithreading would not work with embedded SQL, perhaps because they appear to run in *DFTACTGRP.
Anyone know if embedded SQL can be multithreaded.

Regards, Peter

############################################################## This correspondence is for the named person's use only. It may contain confidential or legally privileged information, or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the views of Veda. If you need assistance, please contact Veda :- Australia http://www.veda.com.au/contact-us New Zealand http://www.veda.co.nz/contact-veda ##############################################################