Category:Embedded SQL Guide
From InterBase
Pages in category "Embedded SQL Guide"
The following 200 pages are in this category, out of 276 total.
(previous page) (next page)A
- A Complete Cursor Example
- A Multi-transaction Example
- Access Mode
- Accessing an Open Database
- Accessing Arrays
- Accessing Blob Data with API Calls
- Accessing Blob Data with SQL
- Accessing Databases (Using Dynamic SQL)
- Adding a New Column to a Table (Embedded SQL Guide)
- Adding and Subtracting Date and Time Data Types
- Additional CONNECT Syntax
- Additional InterBase Error Handling
- Aligning Numerical Data (Embedded SQL Guide)
- Altering a Table
- Altering a View
- Altering an Index
- Altering Metadata
- Appending Tables with UNION
- Attaching to Multiple Databases
B
C
- Capturing InterBase Error Messages (Embedded SQL Guide)
- Capturing SQL Error Messages (Embedded SQL Guide)
- Casting from Date and Time Data Types to Other SQL Data Types
- Casting from SQL Data Types to Date and Time Data Types
- Changing Evaluation Order of Operators
- Choosing Between SNAPSHOT and READ COMMITTED
- Choosing Join Columns
- Closing a Database
- Closing Databases
- Closing the Cursor
- Closing Transactions
- Coercing Data Types (Embedded SQL Guide)
- Combining Error-handling Techniques
- Committing Without Freeing a Transaction
- Comparing Dates and Times
- Comparing SNAPSHOT, READ COMMITTED, and SNAPSHOT TABLE STABILITY
- Compiling an Ada Program
- Compiling and Linking (Embedded SQL Guide)
- Controlling SET DATABASE Scope
- Correlated Subqueries
- Creating a Database (Creating Metadata)
- Creating a Database Using Dynamic SQL
- Creating a Domain
- Creating a Table (Embedded SQL Guide)
- Creating a View
- Creating an Index
- Creating Arrays
- Creating Generators (Embedded SQL Guide)
- Creating Metadata
- Creating Multi-dimensional Arrays
D
- Declaring a Cursor
- Declaring a Database
- Declaring a DSQL Cursor
- Declaring an XSQLDA
- Declaring and Initializing Databases
- Declaring Host Variables
- Declaring Multiple Databases
- Declaring Transaction Names
- Defining the Blob Control Structure (Embedded SQL Guide)
- Defining the Filter Function (Embedded SQL Guide)
- Deleting Blob Data
- Deleting Data (Embedded SQL Guide)
- Deleting Multiple Rows
- Deleting Through a View
- Determining Precedence of Operators
- Differentiating Table Names
- Displaying Error Messages
- Dropping a Table (Embedded SQL Guide)
- Dropping a View
- Dropping an Existing Column
- Dropping an Index
- Dropping Metadata
- DSQL Limitations (Application Requirements)
- DSQL Limitations (Using Dynamic SQL)
- DSQL Programming Methods (Embedded SQL Guide)
- DSQL Requirements (Embedded SQL Guide)
E
F
H
I
- Initializing Transaction Names
- Input Descriptors (Embedded SQL Guide)
- Inserting Blob Data
- Inserting Data (Embedded SQL Guide)
- Inserting Data into an Array
- Inserting Data Through a View (Embedded SQL Guide)
- Inserting Dates and Times
- Inserting Rows with NULL Column Values
- Isolation Level
- Isolation level interactions (Embedded SQL Guide)
L
M
- Metadata Names
- Method 1: Non-query Statements Without Parameters (Embedded SQL Guide)
- Method 2: Non-query Statements with Parameters (Embedded SQL Guide)
- Method 3: Query Statements Without Parameters (Embedded SQL Guide)
- Method 4: Query Statements with Parameters (Embedded SQL Guide)
- Microsoft Windows
- Modifying a Column
- Modifying Transaction Behavior with “?”
N
O
P
- Porting Considerations for DSQL
- Porting Considerations for SQL
- Precedence Among Operators
- Preprocessing
- Preprocessing and Run Time Databases
- Preprocessing Programs
- Preprocessing, Compiling, and Linking
- Processing Array Data (Using Dynamic SQL)
- Processing Blob Data (Using Dynamic SQL)
- Programming Filter Function Actions (Embedded SQL Guide)
R
S
- Section Declarations
- Selecting a Single Row
- Selecting Blob Data
- Selecting Data from an Array
- Selecting Dates and Times
- Selecting from an Array Slice
- Selecting Multiple Rows
- Selecting Multiple Rows in DSQL
- Selecting Rows Through a View
- Selecting Rows with NULL Values
- Setting Database Cache Buffers
- Setting gpre Client Dialect
- Signaling Event Occurrences
- Simple Subqueries
- Solaris
- Sorting Rows with ORDER BY
- Specifying a Connection Character Set
- Specifying a Query Plan with PLAN
- Specifying Host Variables with INTO
- Specifying SET TRANSACTION Behavior
- Specifying Subscript Ranges
- Specifying the Source File
- Specifying Transaction Names in a DELETE
- Specifying Transaction Names in an INSERT
- Specifying Transaction Names in UPDATE
- Specifying Transaction Names When Using Commit
- Specifying Transaction Names When Using Select
- SQL Character Strings
- SQL Data Type Macro Constants (Embedded SQL Guide)
- SQL Statements
- SQL Statements that DSQL Can Process
- Standard Error Handling
- Starting a Named Transaction
- Starting a transaction with READ COMMITTED isolation level
- Starting a Transaction with SNAPSHOT Isolation Level
- Starting a transaction with SNAPSHOT TABLE STABILITY isolation level
- Starting the Default Transaction
- Starting With SET TRANSACTION
- Starting Without SET TRANSACTION
- Supported Data Types