Index
A
B
C
D
E
F
G
H
I
J
K L
M
N
O
P
Q
R
S
T
U
V
W
X Y Z
A
Additional Resources
Additional Resources
Additional Resources
Additional Resources
Additional Resources
Advantages of Stored Procedures
Assigning Null Values from SQL Result Sets:SQLCursor.wasNULL Method
Automatic archiving
C
Calling Scalar Functions from a User Defined Scalar Function
Calling Stored Procedures
from stored procedures
Calling Stored Procedures from .NET
Calling Stored Procedures from JDBC
Calling Stored Procedures from ODBC
Calling Stored Procedures from Stored Procedures
Cascading deletes
Cascading updates
Class
SQLCursor
Class reference, Java
Copyright Notice
Create Function
Creating Stored Procedures
c-treeSQL Java class methods
c-treeSQL Java classes
Introduction
Stored Procedure Security
Using c-treeACE SQL Java Classes
D
Debugging Stored Procedures
Debugging Stored Procedures
Introduction
Define
Define
Define
Define
Define
Deleting stored procedures
Description
DhSQLException
DhSQLException.getDiagnostics
DhSQLResultSet
DhSQLResultSet procedure
DhSQLResultSet.insert
DhSQLResultSet.makeNULL
DhSQLResultSet.set
Done
Done
Done
Done
Done
Drop Function
E
Environment variables
Error handling
Executing an SQL Statement
Executing SQL statements
F
FairCom Typographical Conventions
Functions
User Defined Scaler Functions
G
getValue method
Glossary
H
Handling Errors
Handling Null Values
How c-treeACE SQL Interacts with Java
I
Immediate Execution
Implicit Data Type Conversion Between SQL and Java Types
Implicit Data Type Conversion Between SQL and Java Types
OLDROW and NEWROW Objects: Passing Values to Triggers
Passing Values to and From Stored Procedures: Input and Output Parameters
registerOutParam Method: registering the Type of OUT and INOUT Variables
The getValue Method: Pass Values from SQL Result Sets to Variables
Implicit data type conversions
Init
Init
Init
Init
Init
Introduction
Introduction
Introduction
Introduction
Introduction
Introduction to Stored Procedures and Triggers and User Defined Functions
Introductory Tutorial
Invoking Stored Procedures
Invoking User Defined Scalar Functions
J
Java class reference
Introduction
Introduction
Java Class Reference
Java classes
Introduction
Introduction
Stored Procedure Security
Using c-treeACE SQL Java Classes
Java c-treeSQL interaction
Java data type conversions
Java environment variables
Java snippet
M
Manage
Manage
Manage
Manage
Manage
Methods
getValue
setParam
Modifying and Deleting Stored Procedures
Modifying stored procedures
N
NEWROW
Null values
O
OLDROW
OLDROW and NEWROW Objects: Passing Values to Triggers
OLDROW and NEWROW Objects: Passing Values to Triggers
Structure of Triggers
Triggers vs. Stored Procedures vs. Constraints
Overview
P
Passing input values to SQL statements
Passing values from SQL result sets
Passing values to and from stored procedures
Passing Values to and From Stored Procedures: Input and Output Parameters
Passing Values to SQL Statements
Prepared Execution
Procedures
DhSQLReslutSet
Q
Quick Tour
R
Record/Row Locking
registerOutParam Method: registering the Type of OUT and INOUT Variables
Relational Model and Indexing
Restrictions on Calling Java Methods in Stored Procedures
Restrictions on creating Triggers
RESULT clause
Retrieving data
Retrieving Data: the SQLCursor Class
Returning a Procedure Result Set: the RESULT Clause and DhSQLResultSet
Passing Values to and From Stored Procedures: Input and Output Parameters
Returning a Procedure Result Set: the RESULT Clause and DhSQLResultSet
Setting SQL Statement Input Params & Procedure Result SetFields to Null
Returning a result set
S
Security
setParam method
Setting SQL Statement Input Params & Procedure Result SetFields to Null
Setting Up Your Environment to Write Stored Procedures
Snippet, Java
SQL data type conversions
SQL statement execution
SQL statements, immediate execution
SQL statements, prepared execution
SQLCursor
SQLCursor class
SQLCursor.close
SQLCursor.fetch
SQLCursor.found
SQLCursor.getParam
SQLCursor.getValue
SQLCursor.makeNULL
SQLCursor.open
SQLCursor.registerOutParam
SQLCursor.rowCount
SQLCursor.setParam
SQLCursor.wasNULL
SQLCursor.getValue
SQLCursor.wasNULL
SQLIStatement
SQLIStatement.execute
SQLIStatement.getParam
SQLIStatement.makeNULL
SQLIStatement.registerOutParam
SQLIStatement.rowCount
SQLIStatement.setParam
SQLPStatement
SQLPStatement.execute
SQLPStatement.getParam
SQLPStatement.makeNULL
SQLPStatement.registerOutParam
SQLPStatement.rowCount
SQLPStatement.setParam
Stored Procedure Basics
Stored Procedure Security
Stored procedures
basic coding
benefits
calling
calling from stored procedures
creating
debugging
deleting
environment
environment variables
invoking
modifying
overview
passing values
security
structure
transactions
using
versus constraints
versus triggers
writing
Structure of Stored Procedures
Structure of triggers
Description
Structure of Triggers
Summation updates
T
The getValue Method: Pass Values from SQL Result Sets to Variables
The setParam Method: Pass Input Values to SQL Statements
Implicit Data Type Conversion Between SQL and Java Types
Setting SQL Statement Input Params & Procedure Result SetFields to Null
The setParam Method: Pass Input Values to SQL Statements
Transaction Processing
Transactions
Transactions and Stored Procedures
Trigger
basics
Introduction
Introduction
overview
passing values
structures
Description
Structure of Triggers
uses
versus constraints
versus stored procedures
Trigger Basics
Triggers vs. Stored Procedures vs. Constraints
Typical Uses for Triggers
U
User Defined Scalar Function Security
User Defined Scaler Functions
Using c-treeACE SQL Java Classes
Using stored procedures
Introduction
Introduction
Using Stored Procedures
Using Triggers
Using User Defined Scalar Functions
W
What Is a Java Snippet?
With Constants
With Constants and Column References
With parameter reference (ODBC/JDBC)
Writing Stored Procedures