Informix Guide to SQL

Informix Guide to SQL : Reference and Syntax

3 (1 rating by Goodreads)
By (author) 

List price: US$62.00

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

* The authoritative guide to the Informix implementation of SQL * Updated for Informix Dynamic Server.2000 and Informix Enterprise Decision Server * Informix databases, data types, system catalog tables, and environment variables * Updated & expanded! Detailed syntax section covering every SQL and SPL statement * Detailed step-by-step diagrams and complete glossary The indispensable reference to the Informix implementation of SQL-updated for the new Informix Dynamic Server.2000 and Informix Enterprise Decision Server! Completely updated to reflect the new Informix Dynamic Server.2000 and Informix Enterprise Decision Server, this is the most authoritative guide to the Informix implementation of SQL! The Informix Guide to SQL: Reference and Syntax, Second Edition contains comprehensive descriptions of every SQL and Stored Procedure Language (SPL) statement, plus extensive SQL syntax coverage not included in the first edition. Detailed syntax diagrams walk you through every clause of each SQL statement, and syntax tables explain the input parameters for each clause. Coverage includes: * Building object-relational and data warehouse solutions with the Informix implementation of SQL * Cshow more

Product details

  • Paperback | 1776 pages
  • 180.34 x 233.68 x 63.5mm | 2,404.03g
  • Pearson Education (US)
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 2nd edition
  • 0130161667
  • 9780130161666

Table of contents

(NOTE: Each chapter begins with In This Chapter.)I. REFERENCE. Introduction. In This Introduction. About This Manual. Types of Users. SoftwareDependencies. Assumptions About Your Locale. Demonstration Databases. New Features. New Features in Version. 8.3. New Features in Version 9.2. Documentation Conventions. Typographical Conventions. Icon Conventions. Command-Line Conventions. Sample-Code Conventions. Additional Documentation. On-Line Manuals. Printed Manuals. Error Message Documentation. Documentation Notes, Release Notes, Machine Notes. Related Reading. Compliance with Industry Standards. Informix Welcomes Your Comments1. System Catalog. Objects That the System Catalog Tables Track. Using the System Catalog. Accessing the System Catalog. Updating System Catalog Data. Structure of the System Catalog. SYSAGGREGATES. SYSAMS. SYSATTRTYPES. SYSBLOBS. SYSCASTS. SYSCHECKS. SYSCOLATTRIBS. SYSCOLAUTH. SYSCOLDEPEND. SYSCOLUMNS. SYSCONSTRAINTS. SYSDEFAULTS. SYSDEPEND. SYSDISTRIB. SYSERRORS. SYSEXTCOLS. SYSEXTDFILES. SYSEXTERNAL. SYSFRAGAUTH. SYSFRAGMENTS. SYSINDEXES. SYSINDICES. SYSINHERITS. SYSLANGAUTH. SYSLOGMAP. SYSNEWDEPEND. SYSOBJSTATE. SYSOPCLASSES. SYSOPCLSTR. SYSPROCAUTH. SYSPROCBODY. SYSPROCEDURES. SYSPROCPLAN. SYSREFERENCES. SYSREPOSITORY. SYSROLEAUTH. SYSROUTINELANGS. SYSSYNONYMS. SYSSYNTABLE. SYSTABAMDATA. SYSTABAUTH. SYSTABLES. SYSTRACECLASSES. SYSTRACEMSGS. SYSTRIGBODY. SYSTRIGGERS. SYSUSERS. SYSVIEWS. SYSVIOLATIONS. SYSXTDDESC. SYSXTDTYPEAUTH. SYSXTDTYPES. Information Schema. Generating the Information Schema Views. Accessing the Information Schema Views. Structure of the Information Schema Views.2. Data Types. Summary of Data Types. Description of Data Types. BLOB. BOOLEAN. BYTE. CHAR(n ). CHARACTER(n). CHARACTER VARYING(m,r ). CLOB. DATE. DATETIME. DEC. DECIMAL. Distinct. DOUBLE PRECISION. FLOAT(n). INT. INT. INTEGER. INTERVAL. LIST(e). LVARCHAR. MONEY(p,s). MULTISET(e). Named Row. NCHAR(n ). NUMERIC(p,s ). NVARCHAR(m,r ). Opaque. REAL. Row, Named. Row, Unnamed. SERIAL(n ). SERIAL. SET(e). SMALLFLOAT. SMALLINT. TEXT. Unnamed Row. VARCHAR(m,r ). Built-In Data Types. Large-Object Data Types. Time Data Types. Extended Data Types. Complex Data Types. Distinct Data Types. Opaque Data Types. Data Type Casting and Conversion. Using Built-in Casts. Using User-Defined Casts. Determining Which Cast to Apply. Casts for Distinct Types. What Extended Data Types Can Be Cast? Operator Precedence.3. Environment Variables. Types of Environment Variables. Where to Set Environment Variables in UNIX. Where to Set Environment Variables in Windows NT. Using Environment Variables in UNIX. Setting Environment Variables in an Environment-Configuration File. Setting Environment Variables at Login Time. Syntax for Setting Environment Variables. Unsetting Environment Variables. Modifying an Environment-Variable Setting. Viewing Your Environment-Variable Settings. Checking Environment Variables with the chkenv Utility. Rules of Precedence. Using Environment Variables in Windows NT. Setting Environment Variables for Native Windows Applications. Setting Environment Variables forCommand-Prompt Utilities. Rules of Precedence. List of Environment Variables. Environment Variables. AC_CONFIG. ARC_CONFIG. ARC_DEFAULT. ARC_KEYPAD. COCKPITSERVICE. CPFIRST. DBACCNOIGN. DBANSIWARN. DBBLOBBUF. DBCENTURY. DBDATE. DBDELIMITER. DBEDIT. DBFLTMASK. DBLANG. DBMONEY. DBONPLOAD. DBPATH. DBPRINT. DBREMOTECMD. DBSPACETEMP. DBTEMP. DBTIME. DBUPSPACE. DELIMIDENT. ENVIGNORE. FET_BUF_SIZE. IFMX_SMLTBL_BROADCAST_SIZE. IFX_DIRECTIVES. IFX_LONGID. IFX_NETBUF_PVTPOOL_SIZE. IFX_NETBUF_SIZE. IFX_UPDDESC. INFORMIXC. INFORMIXCONCSMCFG. INFORMIXCONRETRY. INFORMIXCONTIME. INFORMIXCPPMAP. INFORMIXDIR. INFORMIXKEYTAB. INFORMIXOPCACHE. INFORMIXSERVER. INFORMIXSHMBASE. INFORMIXSQLHOSTS. INFORMIXSTACKSIZE. INFORMIXTERM. INF_ROLE_SEP. ISM_COMPRESSION. ISM_DEBUG_FILE. ISM_DEBUG_LEVEL. ISM_ENCRYPTION. ISM_MAXLOGSIZE. ISM_MAXLOGVERS. LD_LIBRARY_PATH. LIBPATH. NODEFDAC. ONCONFIG. OPTCOMPIND. OPTMSG. OPTOFC. OPT_GOAL. PATH. PDQPRIORITY. PLCONFIG. PLOAD_LO_PATH. PLOAD_SHMBASE. PSORT_DBTEMP. PSORT_NPROCS. SHLIB_PATH. STMT_CACHE. TERM. TERMCAP. TERMINFO. THREADLIB. XFER_CONFIG.Index of Environment Variables. Appendix A: The stores_demo Database. Appendix B: The sales_demo and superstores_demo Databases. Glossary. Index. II. SYNTAX. Introduction. In This Introduction. About This Manual.Types of Users. Software Dependencies. Assumptions About Your Locale. Demonstration Databases. New Features. New Features in Version 8.3. New Features in Version 9.2. Documentation Conventions. Typographical Conventions. Icon Conventions. Syntax Conventions. Sample-Code Conventions. Additional Documentation. On-Line Manuals. Printed Manuals. On-Line Help. Error Message Documentation. Documentation Notes, Release Notes, Machine Notes. Related Reading. Compliance with Industry Standards. Informix Welcomes Your Comments.1. Overview of SQL Syntax. How to Enter SQL Statements. How to Enter SQL Comments. Categories of SQL Statements. ANSI Compliance and Extensions.2. SQL Statements. ALLOCATE COLLECTION. ALLOCATE DESCRIPTOR. ALLOCATE ROW. ALTER FRAGMENT. ALTER FUNCTION. ALTER INDEX. ALTER PROCEDURE. ALTER ROUTINE. ALTER TABLE. BEGIN WORK. CLOSE. CLOSE DATABASE. COMMIT WORK. CONNECT. CREATE AGGREGATE. CREATE CAST. CREATE DATABASE. CREATE DISTINCT TYPE. CREATE EXTERNAL TABLE. CREATE FUNCTION. CREATE FUNCTION FROM. CREATE INDEX. CREATE OPAQUE TYPE. CREATE OPCLASS. CREATE PROCEDURE. CREATE PROCEDURE FROM. CREATE ROLE. CREATE ROUTINE FROM. CREATE ROW TYPE. CREATE SCHEMA. CREATE SYNONYM. CREATE TABLE. CREATE Temporary TABLE. CREATE TRIGGER. CREATE VIEW. DATABASE. DEALLOCATE COLLECTION. DEALLOCATE DESCRIPTOR. DEALLOCATE ROW. DECLARE. DELETE. DESCRIBE. DISCONNECT. DROP AGGREGATE. DROP CAST. DROP DATABASE. DROP FUNCTION. DROP INDEX. DROP OPCLASS. DROP PROCEDURE. DROP ROLE. DROP ROUTINE. DROP ROW TYPE. DROP SYNONYM. DROP TABLE. DROP TRIGGER. DROP TYPE. DROP VIEW. EXECUTE. EXECUTE FUNCTION. EXECUTE IMMEDIATE. EXECUTE PROCEDURE. FETCH. FLUSH. FREE. GET DESCRIPTOR. GET DIAGNOSTICS. GRANT. GRANT FRAGMENT. INFO. INSERT. LOAD. LOCK TABLE. OPEN. OUTPUT. PREPARE. PUT. RENAME COLUMN. RENAME DATABASE. RENAME TABLE. REVOKE. REVOKE FRAGMENT. ROLLBACK WORK. SELECT. SET AUTOFREE. SET CONNECTION. SET Database Object Mode. SET DATASKIP. SET DEBUG FILE TO. SET DEFERRED_PREPARE. SET DESCRIPTOR. SET EXPLAIN. SET ISOLATION. SET LOCK MODE. SET LOG. SET OPTIMIZATION. SET PDQPRIORITY. SET PLOAD FILE. SET Residency. SET ROLE. SET SCHEDULE LEVEL. SET SESSION AUTHORIZATION. SET STATEMENT CACHE. SET TRANSACTION. SET Transaction Mode. START VIOLATIONS TABLE. STOP VIOLATIONS TABLE. TRUNCATE. UNLOAD. UNLOCK TABLE. UPDATE. UPDATE STATISTICS. WHENEVER.3. SPL Statements. CALL. CASE. CONTINUE. DEFINE. EXIT. FOR. FOREACH. IF. LET. ON EXCEPTION. RAISE EXCEPTION. RETURN. SYSTEM. TRACE. WHILE.4. Segments. Argument. Collection Derived Table. Condition. Database Name. Database Object Name. Data Type. DATETIME Field Qualifier. Expression. External Routine Reference. Identifier. INTERVAL Field Qualifier. Jar Name. Literal Collection. Literal DATETIME. Literal INTERVAL. Literal Number. Literal Row. Optimizer Directives. Owner Name. Quoted String. Relational Operator. Return Clause. Routine Modifier. Routine Parameter List. Shared-Object Filename. Specific Name. Statement Block.Appendix C: Reserved Words for Dynamic Server. Appendix D: Reserved Words for Enterprise Decision Server. Index.show more

Rating details

1 ratings
3 out of 5 stars
5 0% (0)
4 0% (0)
3 100% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X