Home | Previous Page | Next Page

Contents

In This Introduction

About This Manual

Software Dependencies

Assumptions About Your Locale

Demonstration Databases

New Features in Dynamic Server, Version 10.0

Features From Dynamic Server, Version 9.4

Features From Dynamic Server, Version 9.3

Documentation Conventions

Typographical Conventions

Feature, Product, and Platform

Syntax Diagrams

Example Code Conventions

Additional Documentation

Installation Guides

Informix Error Messages

IBM Informix Dynamic Server Version 10.0 and CSDK Version 2.90 Documentation Set

Compliance with Industry Standards

IBM Welcomes Your Comments

In This Chapter

Built-in Access Methods

User-Defined Access Methods

Access to Storage Spaces

Seamless Use of SQL

Access-Method Components

Components That the IBM Informix Database Server Provides

Components That You Provide

Access Method Flow

Locating Purpose Functions

Invoking Purpose Functions

Calling Functions From a Purpose Function

Improving An Access Method

Developing an Access Method

In This Chapter

Choosing Features

Writing Purpose Functions

Starting and Ending Processing

Creating and Dropping Database Objects

Optimizing Queries

Inserting, Deleting, and Updating Data

Registering Purpose Functions

Supplying Routine Modifiers

Registering the Access Method

Testing the Access Method

Creating and Specifying Storage Spaces

Inserting, Querying, and Updating Data

Checking Data Integrity

Dropping an Access Method

Design Decisions

In This Chapter

Storing Data in Shared Memory

Functions That Allocate and Free Memory

Memory-Duration Options

Persistent User Data

Accessing Database and System Catalog Tables

Executing a UDR Across Databases of the Same Database Server Instance

Handling the Unexpected

Using Callback Functions

Using Error Messages

Supporting Data Definition Statements

Interpreting the Table Descriptor

Managing Storage Spaces

Providing Configuration Keywords

Leveraging Indexes on Virtual Tables

Processing Queries

Interpreting the Scan Descriptor

Interpreting the Qualification Descriptor

Qualifying Data

Enhancing Performance

Executing in Parallel

Buffering Multiple Results

Supporting Data Retrieval, Manipulation, and Return

Checking Isolation Levels

Converting to and from Row Format

Determining Transaction Success or Failure

Supplying Error Messages and a User Guide

Avoiding Database Server Exceptions

Notifying the User About Access-Method Constraints

Documenting Nonstandard Features

Purpose-Function Reference

In This Chapter

Purpose-Function Flow

ALTER FRAGMENT Statement Interface

CREATE Statement Interface

DROP Statement Interface

INSERT, DELETE, and UPDATE Statement Interface

SELECT...WHERE Statement Interface

oncheck Utility Interface

Purpose-Function Syntax

Descriptor Function Reference

In This Chapter

Qualification Descriptor

Scan Descriptor

Statistics Descriptor

Table Descriptor

Accessor Functions

mi_eval_am_qual()

mi_init_am_qual()

mi_qual_boolop()

mi_qual_column()

mi_qual_commuteargs()

mi_qual_constant()

mi_qual_constant_nohostvar()

mi_qual_constisnull()

mi_qual_constisnull_nohostvar()

mi_qual_const_depends_hostvar()

mi_qual_const_depends_outer()

mi_qual_funcid()

mi_qual_funcname()

mi_qual_handlenull()

mi_qual_issimple()

mi_qual_needoutput()

mi_qual_negate()

mi_qual_nquals()

mi_qual_setoutput()

mi_qual_setreopt()

mi_qual_setvalue()

mi_qual_value()

mi_scan_forupdate()

mi_scan_isolevel()

mi_scan_locktype()

mi_scan_newquals()

mi_scan_nprojs()

mi_scan_projs()

mi_scan_quals()

mi_scan_setuserdata()

mi_scan_table()

mi_scan_userdata()

mi_tab_amparam()

mi_tab_check_msg()

mi_tab_createdate()

mi_tab_isolevel()

mi_tab_istable()

mi_tab_niorows()

mi_tab_numfrags()

mi_tab_partnum()

mi_tab_rowdesc()

mi_tab_setnextrow()

mi_tab_setniorows()

mi_tab_setuserdata()

mi_tab_spaceloc()

mi_tab_spacename()

mi_tab_spacetype()

mi_tab_update_stat_mode()

mi_tab_userdata()

mi_tstats_setnpages()

mi_tstats_setnrows()

SQL Statements for Access Methods

In This Chapter

ALTER ACCESS_METHOD (+)

CREATE ACCESS_METHOD (+)

Sample Statements

DROP ACCESS_METHOD (+)

Purpose Options

Appendix. Accessibility

Dotted Decimal Syntax Diagrams

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]