Informix Guide to SQL: Reference and Using Triggers

Informix Guide to SQL: Reference and Using Triggers, 1/e

Informix Software, Menlo Park, CA

Published August, 1994 by Prentice Hall PTR (ECS Professional)

See other books about:
Database Management and Design-Computer Science

Summary

INFORMIX Guide to SQL: Tutorial, this comprehensive reference covers the Structured Query Language (SQL) as it is implemented in Informix products.

Outlines the structure and contents of the demonstration database (stores5) and explains the 21 Informix system catalog tables that describe that structure; defines the column data types supported by Informix products and explains data type conversion techniques; describes the various environment variables that can or should be set to properly use Informix products; explains error handling, the system descriptor area and the SQL Descriptor Area (sqlda); details the workings of all the SQL statements supported by Informix products — with step-by-step diagrams explaining every clause of each SQL statement; and shows how to create and use stored procedures. MARKET: A reference to SQL for those who already know how to use computers and who rely on them in their daily work.

Features

describes the structure and contents of the demonstration database (stores5) that is installed with every Informix application development tool.
provides details of the Informix system catalog — 21 system catalog tables that describe the structure of the stores5 database.
defines the column data types supported by Informix products, tells how to convert between different data types, and describes how to use specific values in arithmetic and relational expressions.
describes the various environment variables that can or should be set to properly use Informix products.
explains how errors are handled and tells how to check the contents of the SQL Communications Area (SQLCA) when using selected Informix products.
describes the system descriptor area and the SQL Descriptor Area (sqlda).
explains the workings of all the SQL statements supported by Informix products — with step-by-step diagrams explaining every clause of each SQL statement.
describes how to create and use stored procedures.

Table of Contents

Introduction.
1. The stores5 Database.
2. System Catalog.
3. Data Types.
4. Environmental Variables.
5. Error Handling with SQLCA.
6. Using Descriptors.
7. Syntax.
8. Stored Procedures and SPL.
Glossary.
Index.