The UltraLite Embedded SQL Interface

About this chapter

UltraLite applications interact with their database through a static embedded SQL programming interface, which is a subset of the embedded SQL interface available in Adaptive Server Anywhere. This chapter introduces the UltraLite embedded SQL interface and describes its language and functions.

For information about the full Adaptive Server Anywhere embedded SQL interface, see The Embedded SQL Interface .

Introduction

Structure of embedded SQL programs

User IDs and database authorization

Host variables

Declaring host variables

Data types

Host variable usage

The scope of host variables

Using expressions as host variables

Using host variables in C++

Indicator variables

Using indicator variables to handle NULL

Fetching data

Fetching one row

Fetching multiple rows

Optimizing query operation

Adding synchronization to your application

Using the ULSynchronize function

Using HotSync synchronization

Commit all changes before synchronizing

Getting the initial copy of data in your application

The SQL Communication Area

Fields in the SQLCA

SQLCA management for multi-threaded or reentrant code

Using multiple SQLCAs

Library functions

db_init library function

db_fini library function

ULPalmDBStream library function

ULPalmExit library function

ULPalmLaunch library function

ULSerialStream library function

ULSocketStream library function

ULSynchronize library function

Embedded SQL commands

Persistent-storage parameters


	Expand Search