Informix-ESQL/C Programmer's Manual

Informix-ESQL/C Programmer's Manual
Chapter 15: Determining SQL Statements

Home Contents Index Master Index New Book

Determining SQL Statements

Using Dynamic-Management Structures

A System-Descriptor Area

: Fixed-Length Portion
: An Item Descriptor

An sqlda Structure

: Fixed-Length Portion
: An sqlvar_struct Structure
: Descriptive Information

Using the DESCRIBE Statement

Determining Statement Type

Determining the Data Type of a Column

: Informix-Specific SQL Data Types
: X/Open SQL Data Types
: Constants for ESQL/C Data Types

Checking for a WHERE Clause

Determining Statement Information at Runtime

Handling an Unknown Select List

Handling an Unknown Column List

Determining Unknown Input Parameters

Determining Return Values Dynamically

Handling Statements That Contain User-Defined Data Types

: SQL Statements with Opaque-Type Columns
: SQL Statements with Distinct-Type Columns

Using a Fetch Array

: Allocating Memory for the Fetch Arrays
: Obtaining Values from Fetch Arrays
: Freeing Memory for a Fetch Array

Informix-ESQL/C Programmer's Manual, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.