• Star User Guide
  • Introducing Ingres Star
    • Ingres Star
    • Audience
    • Query Languages
    • Installation Considerations
    • Setup for Remote Database Access
      • Command Syntax for Accessing a Distributed Database
      • Examples: Accessing Distributed Databases
  • Understanding Ingres Star Architecture
    • Distributed Database
      • Creation of a Distributed Database
      • Registration of Distributed Database Tables
      • Population of the Distributed Database
      • Catalogs
      • Object Types
      • Ingres Star Components
      • Security
    • System Architecture
    • Configuration Access Examples
      • Example: Single Node Configuration
      • Example: Two Node Configuration
      • Example: Three Node Configuration
    • Distributed Transactions
      • Two-Phase Commit
      • When Two-Phase Commit Is Not Used
      • Simulated Two-Phase Commit
    • StarView Utility
    • Query Optimizer
  • Preparing to Install Ingres Star
    • Installation Requirements
      • Installation Prompts for Ingres Star
      • Star Server Startup
    • Operating System Requirements
    • How User Authorization to Nodes Is Established
      • Installation Passwords
        • How Installation Passwords Are Set Up
      • User Authorization Using Netutil and Ingnet
      • Global and Private Authorizations
        • Group Accounts
        • Private Accounts
      • How User Authorization to the Local Node Is Established
      • Authorization in Netutil and Inget for Recovery
      • Authorization Examples
        • Example 1
        • Example 2
        • Example 3
        • Example 4
  • Maintaining a Distributed Database
    • Distributed Database Maintenance Tasks
    • VDBA and Distributed Database Maintenance
    • Commands for Performing Distributed Database Maintenance
    • Statements for Performing Distributed Database Maintenance
    • Naming Conventions
      • Database Naming Restrictions
      • Sizing Attributes
      • Server Class
      • Case
        • Installation Options
        • Naming Registration Examples
    • Createdb Command
      • Examples: Createdb
    • Destroydb Command
      • Example: Destroydb
    • Register as Link Statement--Define Database Objects to Ingres Star
      • Register Table as Link Statement--Define Table to Ingres Star
        • Examples: Register Table as Link
      • Register View as Link Statement--Define View to Ingres Star
        • Example: Register View as Link
      • Register Procedure as Link Statement--Define Procedure to Ingres Star
        • Examples: Register Procedure as Link
      • Catalogs for the Register Statement
      • Execute Immediate Statement--Execute Register as Link Statement Dynamically
    • Register as Link with Refresh Statement--Refresh Registration
      • Register as Link with Refresh Restrictions
      • Effects of Register as Link with Refresh
      • Example: Register as Link with Refresh
    • Using Register with Enterprise Access Products
    • Remove Statement--Remove Registration
      • Remove Table Statement
        • Example: Remove Table
      • Remove View Statement
        • Example: Remove View
      • Remove Procedure Statement
        • Example: Remove Procedure
    • Create Statement
      • Create Table Statement
        • Create Table With Syntax
      • Create View Statement
      • Create View Syntax
    • Drop Statement
      • Drop Table Statement
      • Example: Drop Table
      • Drop View Statement
    • Table Registration Using StarView
    • DDL Concurrency Mode
  • Using a Distributed Database
    • Connecting Directly to a Local Database
      • Direct Connect Statement
        • Direct Connect Syntax
      • Direct Disconnect Statement
        • Direct Disconnect Syntax
      • Direct Execute Immediate Statement
        • Example: Direct Execute Immediate
        • Direct Execute Immediate Statement Process
        • Illegal Direct Execute Immediate Statements
        • Avoiding Execute Errors During Two-Phase Commit
      • Direct Connect and Direct Execute Immediate Compared
    • Unloading and Reloading a Database
      • Example: Unloaddb
    • Copying Objects Using copydb
      • Example: Copydb
    • Modifying Catalogs Using sysmod
      • Example: sysmod
    • Updating Catalog Information Using verifydb
      • Examples: verifydb
    • Rolling Back Transactions
    • dbmsinfo( ) Function--Request Information from a Database
    • help register Statement--Get Help with Objects
  • Managing a Distributed Database with StarView
    • StarView Capablilties
    • Moving Around in StarView
      • Operations Menus
        • Long Operations Menus
      • Options for Selecting an Operation
        • Select an Operation by Function Key
      • Context-sensitive Help
        • Error Messages
    • Start StarView
      • StarView Menu Map
      • The DDB Contents Map
    • The StarView Main Frame
      • Select a Distributed Database
        • Select a Distributed Database from a List
    • Node Status and Local Database Types Frame
      • ListObj Operation
      • LDBAttr Operation
      • SQL Operation
      • Tables Operation
      • TestNode Operation
      • TestLDB Operation
      • TestNode versus TestLDB
    • Distributed Database Contents Frame
      • DDB Contents Frame Operations
    • The ObjAttr Operation
    • The Browse Operation
    • The Remove Operation
      • Remove a Registration
    • The Criteria Operation
      • The NodeHelp Operation
      • The LDBHelp Operation
      • The OwnerHelp Operation
    • Register Tables with StarView
      • Register Tables in a Distributed Database
      • Register Other Database Objects
  • Understanding Ingres Star Catalogs
    • Ingres Star Catalogs
      • iidbdb Catalogs
        • The iidatabase Catalog
        • The iistar_cdbs Catalog
        • The iistar_cdbinfo Catalog
        • The iiddb_netcost Catalog
      • Standard Catalogs
      • System Catalogs
    • Mapping Ingres Star Objects
      • Registered Names and Related Catalogs
      • Tables and Related Catalogs
      • Index Mapping
      • Table and Column Mapping
      • Physical Information and Statistics Mapping
      • Local Tables Index Information
      • Views and Related Catalogs
      • Registered Procedures and Related Catalogs
  • A. Release Compatibility
    • Utilities for Updating a Release 6.4 Star Database
      • Ingres Star and Upgradedb
        • Upgradedb Command--Update a Distributed Database
        • Examples: Upgradedb
      • Ingres Star and Upgradefe
        • Upgradefe Command--Update Tools Catalogs
        • Examples: Upgradefe
    • How You Determine Local and Remote RDBMS Server Releases
  • B. SQL Statement Summary
    • Statements Supported by Ingres Star
      • Begin Declare Section
      • Call
      • Commit
      • Connect
      • Copy
      • Create Link
      • Create Table
      • Create View
      • Cursor Statements
      • Declare Table
      • Delete
      • Direct Connect
      • Direct Disconnect
      • Direct Execute Immediate
      • Disconnect
      • Drop
        • Drop Link
      • Dynamic SQL
      • End Declare Section
      • Endselect
      • Execute Immediate
      • Execute Procedure
      • Help
      • Include
      • Inquire_sql
      • Insert
      • Register As Link
      • Register As Link With Refresh
      • Remove
      • Repeat Queries
      • Rollback
      • Savepoint
      • Select
      • Set
      • Set_sql
      • Update
      • Whenever
    • SQL Statements Not Supported by Ingres Star
    • Terminal Monitor Statements Not Supported by Ingres Star
  • C. Standard Catalog Interface
    • Standard Catalog Interface and Ingres Star
    • Catalog Formats
    • Catalogs
      • iialt_columns Catalog
      • iicolumns Catalog
      • iidbcapabilities Catalog
      • iidbconstants Catalog
      • iihistograms Catalog
      • iiindex_columns Catalog
      • iiindexes Catalog
      • iiintegrities Catalog
      • iimulti_locations Catalog
      • iipermits Catalog
      • iiphysical_tables Catalog
      • iiprocedures Catalog
      • iiregistered_ objects Catalog
      • iiregistrations Catalog
      • iistats Catalog
      • iitables Catalog
      • iiviews Catalog

Star User Guide

iiviews Catalog