Index

• ::, cast operator

• 9.3 features, overview

• Access privileges
• Accessibility
• Aggregate function, restrictions in modifiable view
• ALTER FRAGMENT statement
  • ADD clause
  • ATTACH clause
  • DETACH clause
  • DROP clause
  • INIT clause (1), (2)
  • MODIFY clause
• Alter privilege (1), (2)
• ALTER TABLE statement
  • changing column data type
  • changing table type
  • converting to typed table
  • converting to untyped table
  • privilege for
• ANSI-compliant database
  • buffered logging
  • character field length
  • cursor behavior
  • decimal data type
  • description
  • escape characters
  • identifying
  • isolation level
  • owner naming
  • privileges
  • reason for creating
  • SQLCODE
  • table privileges
  • transaction logging
  • transactions
• Archive, and fragmentation
• Attribute
  • identifying
  • important qualities
  • nondecomposable
• Availability, improving with fragmentation

• Bitmap index, description
• BLOB data type
  • description
  • restrictions in named row type
  • SQL restrictions
• Boldface type
• BOOLEAN data type
• Buffered logging
• Building a relational data model
• BYTE data type
  • description
  • restrictions (1), (2)
  • using

• Cardinality
  • constraint
  • in relationship
• Cast
  • built-in
  • CAST AS keywords
  • collection data type
  • collection elements
  • description
  • distinct data type (1), (2)
  • dropping
  • explicit, definition
  • implicit, definition
  • invoking (1), (2)
  • named row type (1), (2)
  • operator
  • row type
  • unnamed row type fields
  • user-defined (1), (2)
• Chaining synonyms
• CHAR data type
• Character field length
  • ANSI vs. non-ANSI
• CHARACTER VARYING data type
• CLOB data type
  • description
  • restrictions in named row type
  • SQL restrictions
• Codd, E. F.
• Code, sample, conventions for
• Code set
  • default
• Collection data type
  • casting
  • casting restrictions
  • different element types
  • element typ
  • explicit cast
  • implicit cast
  • nested
  • restrictions
  • type checking
  • type constructor
• Column
  • defining
  • named row type
  • of fragmented table, modifying
  • unnamed row type
• Column-level privileges
• Command-line conventions
  • how to read
  • sample diagram
• Command script, creating a database
• Complex data types
• Compliance
  • with industry standards
• Composite key
• Concurrency
  • improving with fragmentation
  • SERIAL and SERIAL8 values
• Connect privilege (1), (2)
• Connectivity in relationship (1), (2)
• Constraint
  • cardinality
  • defining domains
  • named row type restrictions
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• CREATE DATABASE statement
  • dimensional data model
  • in command script
  • relational data model
• CREATE FUNCTION statement,
  • cast registration examples
• CREATE INDEX statement
• CREATE TABLE statement
  • description
  • in command script
  • with FRAGMENT BY EXPRESSION clause
• CREATE VIEW statement
  • restrictions
  • using
  • WITH CHECK OPTION keywords
• Cursor behavior
  • ANSI vs. non-ANSI

• Data
  • loading with dbload utility
  • loading with external tables
• Data mart, description
• Data model
  • attribute
  • building
  • defining relationships
  • description
  • dimensional (1), (2), (3)
  • entity relationship
  • many-to-many relationship
  • one-to-many relationship
  • one-to-one relationship
  • relational
  • telephone directory example
• Data type
  • BLOB
  • BYTE
  • changing with ALTER TABLE statement
  • CHAR
  • CHARACTER VARYING
  • choosing
  • chronological
  • CLOB
  • collection type
  • complex types
  • DATE
  • DATETIME
  • DECIMAL (1), (2), (3), (4)
  • distinct
  • fixed-point
  • floating-point
  • INT8
  • INTEGER
  • INTERVAL
  • MONEY
  • NCHAR
  • NVARCHAR
  • opaque types
  • REAL
  • referential constraints
  • row types
  • SERIAL
  • SERIAL, table hierarchies
  • SERIAL8
  • SMALLFLOAT
  • smart large objects
  • TEXT
  • VARCHAR
• Data warehouse, description
• Data-warehousing model.
  • See also Dimensional data model.
• Database
  • demonstration
    • sales_demo (1), (2)
    • superstores_demo
  • naming
  • populating new tables in
  • views on external database
• Database administrator (DBA)
• Database-level privileges
  • Connect privilege
  • database-administrator privilege
  • description
  • Resource privilege
• DATE data type
  • description
  • display format
• DATETIME data type
  • description
  • display format
• DB-Access
  • creating database with
  • UNLOAD statement
• DBA.
  • See also Database administrator.
• DBDATE environment variable (1), (2)
• dbload utility, loading data
• DBMONEY environment variable (1), (2)
• dbslice, role in fragmentation
• dbspace
  • role in fragmentation
  • selecting
• DBTIME environment variable
• DECIMAL data type
  • fixed-point
  • floating-point (1), (2), (3)
• Default locale
• Default value, of a column
• Delete privilege (1), (2)
• DELETE statement
  • applied to view
  • privilege
  • privilege for
• Dependencies, software
• Derived data, produced by view
• Descriptor column
• Dimension table
  • choosing attributes
  • description
• Dimensional data model
  • building
  • dimension elements
  • dimension tables
  • dimensions
  • fact table
  • implementing
  • measures, definition
  • minidimension tables
• Dimensional database, sales_demo
• Distinct data type
  • casting (1), (2)
  • description
• DISTINCT keyword, restrictions in modifiable view
• Distribution scheme
  • changing the number of fragments
  • definition
  • expression-based
    • using
    • with arbitrary rule
    • with range rule
  • hybrid
    • using
  • range
    • using
  • round-robin
    • using
  • system-defined hash
    • using
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
  • related reading
• Documentation conventions
• Documentation Notes
• Domain
  • characteristics
  • column
  • defined
• DROP CAST statement, using

• Element type
• en_us.8859-1 locale
• Entity
  • attributes
  • criteria for choosing
  • definition
  • occurrence
  • represented by a table
  • telephone directory example
• Entity-relationship diagram
  • discussed
  • reading
• Environment, Non-U.S. English
• Environment variables
• Error messages
• Even distribution
• Existence dependency
• EXISTS keyword, use in condition subquery
• Expression, cast allowed in
• Expression-based distribution scheme
  • arbitrary rule
  • description
  • using
  • with range rule
• External tables, loading data with (1), (2)

• Fact table
  • description
  • determining granularity
  • granularity
• Features in 9.3
• Field, in row types
• First normal form
• Fixed and Known Defects File
• Fixed point
• FLOAT data type
• Floating point
• Foreign key
• Fragment
  • altering (1), (2)
  • changing the number of
  • description
• FRAGMENT BY EXPRESSION clause
• Fragmentation
  • across coservers
  • backup-and-restore operations and
  • dbslice role in
  • description
  • expressions, how evaluated
  • goals
  • logging and
  • of smart large objects
  • reinitializing
  • types of distribution schemes
• Fragmented table
  • creating
  • creating from one non-fragmented table
  • modifying
• Functional dependency

• Generalized-key index
  • data warehouse
  • defining
    • on a selection
    • on an expression
    • on joined tables
  • ownership rights
• GK index.
  • See also Generalized-key index.
• GL_DATETIME environment variable
• Global Language Support (GLS)
• GRANT statement
  • database-level privileges
  • table-level privileges
• Granularity, fact table
• GROUP BY keywords, restrictions in modifiable view

• Hash distribution scheme.
  • See also System-defined hash distribution scheme.
• Help
• Hierarchy (1), (2), (3)
  • See also Row type., Table hierarchy., Inheritance.
• Hybrid distribution scheme
  • description (1), (2)
  • using

• Index
  • bidirectional traversal
  • bitmap, description
  • CREATE INDEX statement
  • data-warehousing environments
  • generalized-key (1), (2)
  • named row type restrictions
• Index privilege (1), (2)
• Industry standards, compliance with
• INFORMIXDIR/bin directory
• Inheritance
  • privileges in hierarchy
  • single
  • table hierarchy
  • type
  • type substitutability
• INIT clause
  • ALTER FRAGMENT
  • in a fragmentation scheme
• Insert privilege (1), (2)
• INSERT statement
  • privileges (1), (2)
  • with a view
• Installation Guides
• INT8 data type
• INTEGER data type
• INTERVAL data type
  • description
  • display format
• INTO TEMP keywords, restrictions in view
• ISO 8859-1 code set
• Isolation level, ANSI vs. non-ANSI

• Join, restrictions in modifiable view

• Key
  • composite
  • foreign
  • primary
• Key column
• Keywords
  • in syntax diagrams

• Language privileges
• Light appends, description
• LIST collection type
• Loading data
  • dbload utility
  • external tables
• Locale (1), (2)
• Logging, types
• Logging table
  • characteristics
  • creation (1), (2)

• Machine notes
• Mandatory entity in relationship
• Many-to-many relationship (1), (2), (3)
• Minidimension table, description
• MODE ANSI keywords, logging
• MODIFY clause of ALTER FRAGMENT
• Modifying fragmented tables
• MONEY data type
  • description
  • display format
• MULTISET collection type

• Named row type
  • casting
  • column definition
  • creating a typed table (1), (2)
  • description
  • dropping
  • example
  • naming conventions
  • restrictions
  • when to use
• NCHAR data type
• Nesting
  • collection types
  • row types
• Nondecomposable attributes
• Nonlogging table
  • characteristics
  • creation (1), (2)
• Normal form
• Normalization
  • benefits
  • first normal form
  • of data model
  • rules (1), (2)
  • second normal form
  • third normal form
• NOT NULL keywords, use in CREATE TABLE statement
• Null value
  • defined
  • restrictions in primary key
• NVARCHAR data type

• ON-Archive
• ondblog utility
• One-to-many relationship (1), (2)
• One-to-one relationship (1), (2)
• Online analytical processing (OLAP)
• Online help
• Online manuals
• Online notes
• Online Notes
• Online transaction processing (OLTP)
• ontape utility
• Opaque data type
  • casting
  • description
• Operational data store
• Operational table
• Optional entity in relationship
• ORDER BY keywords, restrictions in view
• Owner naming
  • ANSI vs. non-ANSI
• Ownership

• Performance, buffered logging
• Populating tables
• Predefined data types
• Primary key
  • composite
  • definition
  • system assigned
• Printed manuals
• Privilege
  • ANSI vs. non_ANSI
  • automating
  • column-level
  • Connect
  • database-administrator
  • database-level
  • Delete (1), (2)
  • encoded in system catalog
  • Execute
  • granting
  • Index
  • Insert (1), (2)
  • language
  • needed to create a view
  • on a view
  • Resource
  • routine-level
  • Select (1), (2), (3)
  • table-level
  • typed tables
  • Update (1), (2)
  • users and the public
  • views and
• PUBLIC keyword, privilege granted to all users

• Range distribution scheme
  • description
  • using
• Raw permanent table
  • altering to
  • description
• Recursive relationship (1), (2)
• Redundant relationship
• References privilege
• Referential constraint
  • data type considerations
• Referential integrity, defining primary and foreign keys
• Related reading
• Relational model
  • description
  • resolving relationships
  • rules for defining tables, rows, and columns
• Relationship
  • attribute
  • cardinality
  • cardinality constraint
  • complex
  • connectivity (1), (2)
  • defining in data model
  • entity
  • existence dependency
  • mandatory
  • many-to-many (1), (2)
  • many-to-many, resolving
  • one-to-many (1), (2)
  • one-to-one (1), (2)
  • optional
  • recursive
  • redundant
  • using matrix to discover
• Release Notes
• Repository, description
• Resource privilege (1), (2)
• REVOKE statement, granting privileges
• Role
  • CREATE ROLE statement
  • definition
  • GRANT DEFAULT ROLE statement
  • granting privileges
  • rules for naming
  • SET ROLE statement
  • sysroleauth system catalog table
  • sysusers system catalog table
• Round-robin distribution scheme
  • description
  • using
• Routine-level privileges
• Routine overloading
• Routine resolution
• Row
  • defining
  • in relational model
• Row type
  • casting (1), (2)
  • categories
  • nested
• Rowid

• sales_demo database
  • creating (1), (2)
  • data model
  • data sources for
  • loading
• Sample-code conventions
• sbspace
• Scratch table
• Second normal form
• Security
  • constraining inserted values (1), (2)
  • database-level privileges
  • making database inaccessible
  • restricting access (1), (2), (3)
  • table-level privileges
  • using operating-system facilities
  • with user-defined routines
• Select privilege
  • column level
  • definition
  • with a view
• SELECT statement
  • in modifiable view
  • on a view
  • privilege for (1), (2)
• Semantic integrity
• SERIAL data type
  • as primary key
  • description
  • initializing
  • referential constraints
  • reset starting point
  • restrictions (1), (2), (3), (4)
  • table hierarchy
• SERIAL8 data type
  • description
  • initializing
  • referential constraints
  • restrictions (1), (2), (3), (4)
  • table hierarchy
• SET collection type
• Single inheritance
• SMALLFLOAT data type
• SMALLINT data type
• Smart large object
  • description
  • fragmenting
  • functions for copying
  • importing and exporting
  • sbspace storage for
  • SQL interactive uses
  • SQL restrictions
• Software dependencies
• SQL code
• SQLCODE, ANSI vs. non-ANSI
• Standard permanent table
  • altering to
  • description
• Star-join schema
  • See also Dimensional data model.
  • description
• Static table
• stores_demo database
• Substitutability
• Subtable
• Subtype
• superstores_demo database (1), (2)
• Supertable
• Supertype
• Synonym
  • chains
  • in ANSI-compliant database
• Synonyms for table names
• Syntax diagrams
  • conventions for
  • keywords in
  • variables in
• Syntax segment
• sysfragexprudrdep system catalog table
• sysfragments system catalog table
• syssyntable system catalog table
• System catalog table
  • privileges
  • syscolauth
  • sysfragexprudrdep
  • sysfragments
  • systabauth
  • sysusers
• System-defined hash distribution scheme
  • description
  • using
• System requirements
  • database
  • software

• Table
  • composite key, defined
  • converting to untyped table
  • converting untyped to typed
  • creating a table
  • descriptor column
  • dropping
  • foreign key, defined
  • index, creating
  • key column
  • loading data into
  • names, synonyms
  • ownership
  • primary key in
  • privileges
  • relational model
  • represents an entity
• Table hierarchy
  • adding new tables
  • defining
  • description
  • inherited properties
  • modifying table behavior
  • SERIAL types
  • triggers
• Table inheritance, definition
• Table-level privileges
  • access privileges
  • Alter privilege
  • definition and use
  • Index privilege
  • References privilege
• Temp table
• TEXT data type
  • description
  • restrictions (1), (2)
  • using
• Third normal form
• TOC Notes
• Transaction
  • ANSI vs. non-ANSI
  • definition
• Transaction logging
  • ANSI vs. non-ANSI
  • buffered
  • establishing with CREATE DATABASE statement
  • turning off for faster loading
• Transitive dependency
• Type constructor
• Type hierarchy
  • creating
  • description
  • dropping row types from
  • overloading routines
• Type inheritance, description
• Type substitutability
• Typed table
  • See also Fragmented table.
  • creating from an untyped table (1), (2)
  • definition
• Typographical conventions

• UNION keyword
  • in a view definition
  • restrictions in modifiable view
• UNIQUE keyword
  • constraint in CREATE TABLE statement
  • restrictions in modifiable view
• Unnamed row type
  • description
  • example
  • restrictions
• Untyped table
  • converting to a typed table (1), (2)
  • definition
• Update privilege
  • definition
  • with a view
• UPDATE statement
  • applied to view
  • privilege for (1), (2)
• User-defined cast
  • between data types
• User-defined data type
  • casting
  • description
• User-defined routine
  • granting privileges on
  • security purposes
• Utility program
  • dbload (1), (2), (3)

• VARCHAR data type
• Variables, in syntax diagrams
• View
  • creating
  • deleting rows
  • description
  • dropped when basis is dropped
  • effect of changing basis
  • effects when changing the definition of
  • inserting rows in
  • modifying
  • null inserted in unexposed columns
  • privileges
  • restrictions on modifying
  • typed
  • updating duplicate rows
  • using WITH CHECK OPTION keywords
  • virtual column

• WHERE keyword, enforcing data constraints
• WITH CHECK OPTION keywords, CREATE VIEW statement