Working with the SQLite Persistent Interface

Sybase IQ InfoPrimer technology includes a built-in, general purpose, relational database you can use for temporary data storage and staging. It is based on SQLite, a very fast, widely used, mostly SQL92-compliant database. SQLite is a small C library that implements a self-contained, embeddable, zero configuration SQL database engine.

Connecting to a SQLite Database
A SQLite database is represented as a single file with the .db extension. The database file can contain any number of tables.
Creating a SQLite Table
Create a SQLite table using one of the specified ways.
Extracting Data from a SQLite Database
Provide the proper connection parameters for the SQLite database file on a DB component.

Parent topic: Connection Parameters

Created May 24, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com