|Home||Contents||Index||Master Index||New Book|
About This ManualThe Informix Guide to SQL: Syntax manual contains syntax descriptions for the Structured Query Language (SQL) and Stored Procedure Language (SPL) statements that Universal Server supports.
This manual is part of a series of manuals that discusses the Informix implementation of SQL. This volume and the Informix Guide to SQL: Reference are references that you can use on a daily basis after you finish reading the Informix Guide to SQL: Tutorial.
Organization of This ManualThis manual includes the following chapters:
Types of UsersThis manual is written for SQL users, database administrators and SQL developers who use Informix products and SQL on a regular basis.
Software DependenciesThis manual assumes that you are using the following Informix software:
Assumptions About Your LocaleInformix products can support many languages, cultures, and code sets. All culture-specific information is brought together in a single environment, called a GLS (Global Language Support) locale.
This manual assumes that you are using the default locale, en_us.8859-1. This locale supports U.S. English format conventions for dates, times, and currency. In addition, this locale supports the ISO 8859-1 code set, which includes the ASCII code set plus many 8-bit characters such as é, è, and ñ.
If you plan to use nondefault characters in your data or your SQL identifiers, or if you want to conform to the nondefault collation rules of character data, you need to specify the appropriate nondefault locale(s). For instructions on how to specify a nondefault locale, additional syntax, and other considerations related to GLS locales, see the Guide to GLS Functionality.
Demonstration DatabaseThe DB-Access utility, which is provided with your Informix database server products, includes a demonstration database called stores7 that contains information about a fictitious wholesale sporting-goods distributor. Sample command files are also included.
Many examples in Informix manuals are based on the stores7 demonstration database. The stores7 database is described in detail and its contents are listed in Appendix A of the Informix Guide to SQL: Reference.
The script that you use to install the demonstration database is called dbaccessdemo7 and is located in the $INFORMIXDIR/bin directory. For a complete explanation of how to create and populate the demonstration database on your database server, refer to the DB-Access User Manual.