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