INFORMIX cursors in shared memory

Posted in 1991

Walt Hultgren {rmy} — Sat, 2 Nov 91 00:00:15 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!att!cbnewsm!cbnewsk!chardin From: chardin@cbnewsk.att.com (christopher.hardin) Newsgroups: comp.databases.informix Message-ID: <1991Nov1.223846.1316@cbnewsk.att.com> Date: 1 Nov 91 22:38:46 GMT Organization: AT&T Bell Laboratories Greetings, Imagine a program that could be fed SQL statements like SELECT or UPDATE and execute them in ESQL/C. Now imagine several of these things running at the same time. It would be nice if any available server could take up where the last one left off. Users would send SQL statements down the pike and the next available INFORMIX server does the request. Here's my question: to do this it would be nice to put the INFORMIX cursors into shared memory. This way each sever doesn't have to reissue SELECT statements. Can this be done? If so, how? I have INFORMIX SE, SQL, ESQL/C Version 4.00 UD2 running UNIX SV3.2.2 on a 386 box. Also, does INFORMIX support sql1() and sql2() function calls in ESQL/C? Oracle and Faircom (ctree) support them. -- Chris Hardin chris@green.att.com ...!att!green!chris 404.750.8921