Execute SQL statements in parallel (esqlc)

Posted in 2016

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

STEVEN BLACK — Mon, 29 Feb 2016 18:53:20 — source: IIUG Forums & Mailing Lists

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

↪ replying to STEVEN BLACK

John Miller iii — Mon, 29 Feb 2016 19:13:31 — source: IIUG Forums & Mailing Lists

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. >

↪ replying to STEVEN BLACK

Sathyanesh — Mon, 29 Feb 2016 19:27:33 — source: IIUG Forums & Mailing Lists

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.

↪ replying to Sathyanesh

STEVEN BLACK — Tue, 01 Mar 2016 14:17:42 — source: IIUG Forums & Mailing Lists

Thank you John & Sathyanesh for the quick responses. I will take a look at the writing the esql/c thread routines. Regards, Steve

Glossary

ESQL/C