DB2 Server for VSE & VM: Application Programming

Appendix B. Using SQL in C

Partial Table-of-Contents

A C Sample Program

Rules for Using SQL in C

Placing and Continuing SQL Statements

Delimiting SQL Statements

Identifying Rules for Case

Identifying Rules for Character Constants

Using the INCLUDE Statement

Using the CONNECT Statement (DB2 Server for VSE)

Using the C Compiler Preprocessor

Declaring Host Variables

Using Host Variables in SQL Statements

Using the Pointer Type Attribute

Using Host Variables as Function Parameters

Using C Variables in SQL: Data Conversion Considerations

Using C NUL-Terminated Strings and Truncation

Calculating Dates

Using Trigraphs

Using DBCS Characters in C

Considering Preprocessor-Generated Statements

Handling SQL Errors

Using Dynamic SQL Statements in C

Defining DB2 Server for VSE & VM Data Types for C

Using Reentrant C Programs

Using Stored Procedures

Contents

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]