Home
|
Previous Page
|
Next Page
Contents
Introduction
In This Introduction
About This Manual
Types of Users
Software Dependencies
Assumptions About Your Locale
New Features
Documentation Conventions
Typographical Conventions
Feature, Product, and Platform
Syntax Diagrams
Example Code Conventions
Additional Documentation
Installation Guides
Online Notes
Informix Error Messages
Manuals
Online Help
Accessibility
IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set
Compliance with Industry Standards
IBM Welcomes Your Comments
Getting Started with DB-Access
In This Chapter
What Is DB-Access?
Using DB-Access
Setting Up DB-Access
Pre-DB-Access Installation
Environment Variables
Creating and Working with the Demonstration Databases
Demonstration Databases
Demonstration Installation
Command-Line Syntax
Privileges for the Demonstration Database
Permissions for the SQL Command Files
Invoking DB-Access
Starting the DB-Access Menu Interface
Executing a Command File
Viewing the Information Schema
Checking for ANSI Compliance
Checking the Scale of DECIMAL(p) Values
Activating the XLUF Feature for Nonprintable Characters
Using DB-Access Interactively in Non-Menu Mode
Related Manuals
Using the Full-Screen Menu Interface
In This Chapter
Using the DB-Access User Interface
Using the Keyboard with DB-Access
Using Menus
Using Response Screens
Using the HELP Screen
Using an Editor Screen
Alternative Approaches
Database-Level Tasks
Table-Level Tasks
Related Manuals
The Query-language Option
In This Chapter
Overview of the SQL Menu
Using a System Editor
The Query-language Option
Entering a New SQL Statement
Using the Editing Keys
Editing Restrictions
Running an SQL Statement
Statements That the Run Option Supports
Viewing Successful Results
What Happens When Errors Occur
Modifying an SQL Statement
Redirecting Query Results
Sending Output to a Printer
Sending Output to a File
Sending Output to a Pipe
Choosing an Existing SQL Statement
Saving the Current SQL Statement
Displaying Table Information
Dropping an SQL Statement
Support for SPL Routines
Related Manuals
The Database Option
In This Chapter
Selecting a Database Menu Option
Selecting a Database
List of Available Databases
Specifying a Database
Creating a Database
Specifying a Dbspace
Specifying Logging
Exiting the CREATE DATABASE Menu
Displaying Database Information
Retrieving Information on Dbspaces
Retrieving Nondefault Locale Information
Retrieving Information on Routines
Selecting a Different Database
Deleting a Database
The DROP DATABASE Screen
Confirming Your Decision to Delete a Database
Closing a Database
Related Manuals
The Table Option
In This Chapter
The TABLE Menu
Creating or Altering a Table
The CREATE TABLE Screen
The ALTER TABLE Screen
Using the Schema Editor
Adding Columns to a Table (Add Option)
Building the Table (Exit Option)
Modifying Columns (Modify Option)
Deleting Columns (Drop Option)
Arranging Storage and Locking (Table_options)
Defining Constraints
Displaying Table Information
Displaying Column Information
Displaying Index Information
Displaying Table-Level Privileges
Displaying References Privileges
Displaying Column Constraints and Defaults
Displaying Triggers
Displaying Fragmentation Information
Dropping a Table
Moving a Table (XPS)
Related Manuals
The Connection and Session Options
In This Chapter
Choosing the Connection Option
Connecting to a Database Environment
Disconnecting from a Database Environment
Transaction Processing
Choosing the Session Option
Appendix A. How to Read Online Help for SQL Statements
Appendix B. Demonstration SQL
SQL Files for the Relational Database Model
alt_cat.sql
c_calls.sql
c_cat.sql
c_custom.sql
c_index.sql
c_items.sql
c_manuf.sql
c_orders.sql
c_proc.sql
c_state
c_stock.sql
c_stores.sql
c_table.sql
c_trig.sql
c_type.sql
c_view1.sql
c_view2.sql
d_proc.sql
d_trig.sql
d_view.sql
del_stock.sql
ins_table.sql
opt_disk.sql
sel_agg.sql
sel_all.sql
sel_group.sql
sel_join.sql
sel_ojoin1.sql
sel_ojoin2.sql
sel_ojoin3.sql
sel_ojoin4.sql
sel_order.sql
sel_sub.sql
sel_union.sql
upd_table.sql
SQL Files for the Dimensional Database Model
createdw.sql
loaddw.sql
User-Defined Routines for the Object-Relational Database Model
Appendix C. Accessibility
Dotted Decimal Syntax Diagrams
Notices
Trademarks
Index
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]