informix
INFORMIX-ESQL/C Programmer's Manual
Programming with INFORMIX-ESQL/C

Programming with INFORMIX-ESQL/C

What Is INFORMIX-ESQL/C?
ESQL/C Components
ESQL/C Files for Windows
ESQL/C Library Functions
Creating an ESQL/C Program
Embedding SQL Statements
Handling Case Sensitivity in Embedded SQL Statements
Using Quotes and Escape Characters
Including Newline in Quoted Strings
Adding Comments
Specifying Host Variables
Declaring and Using Host Variables
Declaring a Host Variable
Host-Variable Names
Host-Variable Data Types
Initial Host-Variable Values
Scope of Host Variables
Sample Host-Variable Declarations
Assigning a Value to a Host Variable
SQL Identifiers
Null Values in Host Variables
Using Host Variables in Data Structures
Arrays of Host Variables
C Structures as Host Variables
C typedef Statements as Host Variables
Pointers as Host Variables
Function Parameters as Host Variables
Using Host Variables in Windows Environments
Declaring Variables with Non-ANSI Storage-Class Modifiers
Using Indicator Variables
Declaring Indicator Variables
Associating an Indicator Variable with a Host Variable
Indicating Null Values
Indicating Truncated Values
An Example Using Indicator Variables
Using ESQL/C Header Files
Declaring Function Prototypes
Including Header Files
Using ESQL/C Preprocessor Directives
The include Directive
The define and undef Directives
The ifdef, ifndef, elif, else, and endif Directives
Setting and Retrieving Environment Variables in Windows Environments
InetLogin Structure
Fields of the InetLogin Structure
InetLogin Field Values
Precedence of Configuration Values
Using Global ESQL/C Variables in a Windows Environment
A Sample INFORMIX-ESQL/C Program
Compiling the demo1 Program
Guide to demo1.ec File

INFORMIX-ESQL/C Programmer's Manual, Version 9.21
Copyright © 1999, Informix Software, Inc. All rights reserved