Re: esql questions

Posted in 1996

Peter Sylvester — Wed, 17 Jul 1996 07:29:12 -0400 — source: Informix-list mailing list archive (1991-1998)

roland@amarex.com wrote: > > I am looking for any info on ESQL/C. Specifically, I'd like to know how to open multiple databases within the same process. I'd also like to know how to set t > queries. > Roland > roland@amarex.com You need to check out the Informix ESQL/C Programmer's manual, and the Informix Guide to SQL Syntax. try: EXEC SQL CONNECT 'db1' WITH CONCURRENT TRANSACTION; ... EXEC SQL CONNECT 'db2'; ... EXEC SQL SET CONNECTION 'db1'; To interrupt long select statements, I think you have to setup a signal handler for a timer which calls sqlbreak(). Again, the ESQL/C manual has details on alot of this.