Execute SQL statements in parallel (esqlc)
Steven Black (IDS 11.50.FC6W2, CSDK 3.50, Solaris) asked whether SQL statements can run in parallel in one ESQL/C program and whether a UDR is needed. John Miller III advised a POSIX-threaded ESQL program with one connection per thread. Sathyanesh agreed, noting only one connection is active per thread. Steve planned to write thread routines.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
IBM Informix Dynamic Server Version 11.50.FC6W2 IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC6 SunOS cycle 5.10 Generic_150400-30 sun4u sparc SUNW,SPARC-Enterprise cc: Sun C 5.9 SunOS_sparc Patch 124867-01 2007/07/12 Is it possible to execute SQL statements in parallel within a single ESQL/C program. Is UDR required for this purpose? Thanks, Steve
You can write a posix threaded esql program with multiple connection each executing a sql statement/transaction. John Sent from my iPhone > On Feb 29, 2016, at 10:54 AM, STEVEN BLACK <steven=5Fblack@yahoo.com> wrote: > > IBM Informix Dynamic Server Version 11.50.FC6W2 > IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC6 > SunOS cycle 5.10 Generic=5F150400-30 sun4u sparc SUNW,SPARC-Enterprise > cc: Sun C 5.9 SunOS=5Fsparc Patch 124867-01 2007/07/12 > > Is it possible to execute SQL statements in parallel within a single ESQL/C > program. > > Is UDR required for this purpose? > > Thanks, > Steve > > > ***************************************************************************= **** > Forum Note: Use "Reply" to post a response in the discussion forum. >
Hi Steve, You may execute each ESQL/C statements on separate threads. FYI: Though ESQL/C has multi threading support At any given time only one connection will be active per thread (the remaining connection on that thread will go in dement state) Regards, Satyan Advisory Software Engineer R&D - IBM Information Management Division 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) From: "STEVEN BLACK" <steven=5Fblack@yahoo.com> To: ids@iiug.org Date: 02/29/2016 12:54 PM Subject: Execute SQL statements in parallel (esqlc) [36652] Sent by: ids-bounces@iiug.org IBM Informix Dynamic Server Version 11.50.FC6W2 IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC6 SunOS cycle 5.10 Generic=5F150400-30 sun4u sparc SUNW,SPARC-Enterprise cc: Sun C 5.9 SunOS=5Fsparc Patch 124867-01 2007/07/12 Is it possible to execute SQL statements in parallel within a single ESQL/C program. Is UDR required for this purpose? Thanks, Steve ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you John & Sathyanesh for the quick responses. I will take a look at the writing the esql/c thread routines. Regards, Steve