Or a JOIN could do the trick in a single statement: Such as SELECT * FROM SYSSPEC.MYFILE a, SOMPFM03 b WHERE a.ACTNBR = b.ACCTNMBR or SELECT count(*) FROM SYSSPEC.MYFILE a, SOMPFM03 b WHERE a.ACTNBR = b.ACCTNMBR On 3/6/07, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx> wrote:
> From: David Gibbs > > > Actually, you aren't even using PareparedStatement's correctly in this > case ... for what you are doing, a simple Statement would suffice > (closing it after you're done, of course). Not only that, but depending on the number of statements that need to be processed, it might be faster to build a single UNION and execute the whole thing at one time. Joe -- This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/java400-l or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.