Re: Two simple questions

>From: charliep@earlham.edu >Subject: Two simple questions >Date: Fri, 13 May 94 10:02:55 -500 >X-Informix-List-Id: <news.6728> > >Two questions from a neophyte: 2? I make it 5. >1. Does Informix support an API to SE and/or OnLine? I am looking for > something like Oracle's OCI or Sybase's DB-LIB rather than the > pre-compiled ESQL. No. >2. How is the concept of "user" handled in OnLine? By default, the database user is the Unix user. >3. When I looked at the ESQL demo programs there is no connect verb, > everything seems to depend on the OS username. Version 6.0 supports CONNECT, SET CONNECTION and DISCONNECT, optionally specifying user id and password. >4. If I attempt to manage multiple transactions from the same OS process > my commits/rollbacks seem to affect _all_ the transactions. Unless you are using Version 6.0, you cannot have multiple transactions, period. Therefore the commit/rollback affects the only transaction that is current. >5. Is it possible to establish separate user contexts within the same OS > process? I suspect that using multiple connections, probably with the WITH CONCURRENT TRANSACTION option, will achieve most of what you are seeking. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>