INFORMIX-ESQL/C Programmer's Manual Determining SQL Statements

Using Dynamic-Management Structure

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