Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Other Syntax Segments

In This Chapter
Arguments
Comparing Arguments to the Parameter List
Subset of Expressions Valid as an Argument
Arguments to UDRs in Remote Databases
Related Information
Collection-Derived Table
Accessing a Collection Through a Virtual Table
Restrictions with the Collection-Expression Format
Additional Restrictions That Apply to ESQL/C
Row Type of the Resulting Collection-Derived Table
Accessing a Collection Through a Collection Variable
Using a Collection Variable to Manipulate Collection Elements
Example of Deleting from a Collection in ESQL/C
Example of Deleting from a Collection
Example of Updating a Collection
Example of Inserting a Value into a Multiset Collection
Accessing a Nested Collection
Accessing a Row Variable
Related Information
Database Name
Using the @ Symbol
Using a Path-Type Naming Notation
Using a Host Variable
Database Object Name
Specifying a Database Object in an External Database
Specifying a Database Object in a Cross-Database Query
Specifying a Database Object in a Cross-Server Query
Routine Overloading and Naming UDRs with a Routine Signature (IDS)
Specifying an Existing UDR
Owners of Objects Created by UDRs
External Routine Reference
VARIANT or NOT VARIANT Option
Example of a C User-Defined Function
Identifier
Use of Uppercase Characters
Use of Keywords as Identifiers
Support for Non-ASCII Characters in Identifiers
Delimited Identifiers
Support for Nonalphanumeric Characters
Support for Non-ASCII Characters in Delimited Identifiers (GLS)
Effect of DELIMIDENT Environment Variable
Examples of Delimited Identifiers
Using Double Quotes Within a Delimited Identifier
Potential Ambiguities and Syntax Errors
Using the Names of Built-In Functions as Column Names
Using Keywords as Column Names
Using ALL, DISTINCT, or UNIQUE as a Column Name
Using INTERVAL or DATETIME as a Column Name
Using rowid as a Column Name (IDS)
Workarounds that Use the Keyword AS
Using AS with Column Labels
Using AS with Table Aliases
Fetching Cursors that have Keywords as Names
Fetching Cursors that have Keywords as Names
Using CURRENT, DATETIME, INTERVAL, and NULL in INSERT
Using NULL and SELECT in a Condition
Using ON, OFF, or PROCEDURE with TRACE
Using GLOBAL as the Name of a Variable
Using EXECUTE, SELECT, or WITH as Cursor Names
SELECT Statements in WHILE and FOR Statements
SET Keyword in the ON EXCEPTION Statement
Related Information
Jar Name
Optimizer Directives
Optimizer Directives as Comments
Restrictions on Optimizer Directives
Access-Method Directives
Join-Order Directive
Join-Method Directives
Optimization-Goal Directives (IDS)
Explain-Mode Directives
Rewrite Method Directive (XPS)
Related Information
Owner Name
Using Quotation Marks
Accessing Information from the System Catalog Tables
ANSI-Compliant Database Restrictions and Case Sensitivity
Setting ANSIOWNER for an ANSI-Compliant Database
Default Owner Names
Purpose Options
Purpose Options for Access Methods
Purpose Functions, Methods, Flags, and Values
Purpose Options for XA Data Source Types
Return Clause
Limits on Returned Values
Subset of SQL Data Types
Returning a Value from Another Database (IDS)
Using the REFERENCES Clause to Point to a Simple Large Object
Named Return Parameters (IDS)
Cursor and Noncursor Functions
Routine Modifier
Adding or Modifying a Routine Modifier
Modifier Descriptions
CLASS
COSTFUNC
HANDLESNULLS
INTERNAL
ITERATOR
NEGATOR
PARALLELIZABLE
PERCALL_COST (C)
SELCONST (C)
SELFUNC (C)
Concept of Selectivity
Restrictions on the SELFUNC Modifier
STACK (C)
VARIANT and NOT VARIANT
Related Information
Routine Parameter List
Subset of SQL Data Types
Using the LIKE Clause
Using the REFERENCES Clause
Using the DEFAULT Clause
Specifying OUT Parameters for User-Defined Routines
Specifying INOUT Parameters for a User-Defined Routine (IDS)
Shared-Object Filename
C Shared-Object File
Java Shared-Object File
Related Information
Specific Name
Restrictions on the Owner Name
Restrictions on the Specific Name
Statement Block
Subset of SPL Statements Valid in the Statement Block
SQL Statements Not Valid in an SPL Statement Block
Nested Statement Blocks
Scope of Reference of SPL Variables and Exception Handlers
Restrictions on SPL Routines in Data-Manipulation Statements
Transactions in SPL Routines
Support for Roles and User Identity
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]