Informix-ESQL/C Programmer's Manual
Chapter 12: Working with the Database Server
Home
Contents
Index
Master Index
New Book
Working with the Database Server
The Client-Server Architecture of ESQL/C Applications
The Client-Server Connection
Sources of Connection Information on a UNIX Operating System
Accessing the sqlhosts File
Specifying the Default Database Server
Sources of Connection Information in a Windows Environment
Setting Environment Variables for Connection in a Windows Environment
sqlhosts Information in a Windows Environment
Using a Central Registry
Connection Authentication Functionality in a Windows Environment
Connecting to a Database Server
Establishing a Connection
Establishing an Explicit Connection in a Windows Environment
Using Multiplexed Connections
Identifying the Database Server
Interacting with the Database Server
Determining Features of the Database Server
Switching Between Multiple Database Connections
Making a Connection Current
Handling Transactions
Identifying an Explicit Connection
Obtaining Available Databases
Checking the Status of the Database Server
Detaching from a Connection
Interrupting an SQL Request
Interruptible SQL Statements
Allowing a User to Interrupt
Setting Up a Time-Out Interval
Terminating a Connection
Optimized Message Transfers
Restrictions on Optimized Message Transfers
Enabling Optimized Message Transfers
Setting the OPTMSG Environment Variable
Setting the OptMsg Global Variable
Error Handling with Optimized Message Transfers
Using Database Server Control Functions
ifx_getcur_conn_name()
sqgetdbs()
sqlbreak()
sqlbreakcallback()
sqldetach()
sqldone()
sqlexit()
sqlsignal()
sqlstart()
The timeout Program
Compiling the Program
Guide to the timeout.ec File
Example Output
Using ESQL/C Connection Library Functions in a Windows Environment
GetConnect()
ReleaseConnect()
SetConnect()
Informix-ESQL/C Programmer's Manual
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
