| Symbols & Numeric |
| .NET Support |
| .NET Support |
| FairCom Java and .NET Stored Procedures, Triggers, and User Defined Functions |
| .NET Tutorials |
| .NET Support |
| .NET Tutorials |
| A |
| Advantages of Stored Procedures |
| Assigning Null Values from 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 Stored Procedures |
| Cascading deletes |
| Cascading updates |
| Class |
| SQLCursor |
| Class reference, Java |
| Copyright Notice |
| Create Function |
| Create Trigger |
| Creating Stored Procedures |
| c-treeSQL Java class methods |
| c-treeSQL Java classes |
| Stored Procedure Security |
| Using FairCom DB SQL Java Classes |
| D |
| Debugging Java Stored Procedures |
| Debugging Stored Procedures |
| Debugging Stored Procedures |
| Java Class Reference |
| Deleting stored procedures |
| DhSQLException |
| DhSQLException.getDiagnostics |
| DhSQLException.getMessageText |
| DhSQLException.getSqlState |
| DhSQLResultSet |
| DhSQLResultSet procedure |
| DhSQLResultSet.insert |
| DhSQLResultSet.makeNULL |
| DhSQLResultSet.set |
| Drop Function |
| Dynamically Disable Triggers |
| E |
| Enabling Java Debugging Tools |
| Environment variables |
| Error handling |
| Executing an SQL Statement |
| Executing SQL statements |
| F |
| FairCom Java and .NET Stored Procedures, Triggers, and User Defined Functions |
| FairCom Typographical Conventions |
| Functions |
| User Defined Scalar Functions |
| G |
| getValue method |
| Glossary |
| H |
| Handling Errors |
| Handling Null Values |
| 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 |
| Passing Values to SQL Statements |
| registerOutParam Method: registering the Type of OUT and INOUT Variables |
| Implicit data type conversions |
| Introduction |
| Introduction |
| Introduction |
| Invoking Stored Procedures |
| Invoking User-Defined Scalar Functions |
| J |
| Java class reference |
| Introduction |
| Java Class Reference |
| Using Java Stored Procedures |
| Java classes |
| Introduction |
| Stored Procedure Security |
| Using FairCom DB SQL Java Classes |
| Java c-treeSQL interaction |
| Java data type conversions |
| Java environment variables |
| Java Quick Tour |
| Java snippet |
| Java Stored Procedures and Triggers Require JDK V1.7 or Newer |
| Java Stored Procedures, Triggers, and UDFs |
| FairCom Java and .NET Stored Procedures, Triggers, and User Defined Functions |
| Java Stored Procedures, Triggers, and UDFs |
| JSWAT Example |
| L |
| LVARCHAR Fields Allowed in Stored Procedure Code |
| M |
| Mapping Between SQL Types and .NET Types |
| 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 |
| Trigger Basics |
| Overview |
| Overview of Stored Procedures |
| 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 |
| Handling Null Values |
| Implicit Data Type Conversion Between SQL and Java Types |
| Passing Values to SQL Statements |
| Prepared Execution |
| Procedures |
| DhSQLReslutSet |
| R |
| registerOutParam Method: registering the Type of OUT and INOUT Variables |
| 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 with SQLResultSet |
| Handling Null Values |
| Passing Values to and From Stored Procedures: Input and Output Parameters |
| Returning a Procedure Result Set with SQLResultSet |
| 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 |
| SQL Stored Procedures - Close cursors that were left open |
| SQLCursor |
| SQLCursor class |
| SQLCursor.close |
| SQLCursor.fetch |
| SQLCursor.found |
| SQLCursor.getLongValue |
| SQLCursor.getParam |
| SQLCursor.getValue |
| SQLCursor.makeNULL |
| SQLCursor.open |
| SQLCursor.registerOutParam |
| SQLCursor.rowCount |
| SQLCursor.setParam |
| SQLCursor.wasNULL |
| SQLCursor.getValue |
| SQLCursor.wasNULL |
| SqlException |
| SqlException |
| The .NET Ctree.SqlSP Assembly |
| 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 |
| SqlSpBase |
| SqlSpBase |
| SqlStoredProc |
| SqlTrigger |
| SqlUdf |
| The .NET Ctree.SqlSP Assembly |
| SqlSpColumn |
| SqlSpColumn |
| SqlSpRow |
| The .NET Ctree.SqlSP Assembly |
| SqlSpCommand |
| SqlSpCommand |
| The .NET Ctree.SqlSP Assembly |
| SqlSpRow |
| SqlSpRow |
| SqlStoredProc |
| SqlTrigger |
| The .NET Ctree.SqlSP Assembly |
| SqlStoredProc |
| SqlSpBase |
| SqlStoredProc |
| The .NET Ctree.SqlSP Assembly |
| SqlTrigger |
| SqlSpBase |
| SqlTrigger |
| SqlUdf |
| SqlSpBase |
| SqlUdf |
| 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 |
| versus constraints |
| versus triggers |
| writing |
| Structure of Stored Procedures |
| Structure of Triggers |
| Structure of Triggers |
| Structure of User-Defined Functions |
| Structure of User-Defined Functions |
| Summation updates |
| T |
| The .NET Ctree.SqlSP Assembly |
| The getValue Method: Pass Values from SQL Result Sets to Variables |
| The setParam Method: Pass Input Values to SQL Statements |
| Throw Custom Error Message on Stored Procedure or UDF Exception |
| Transactions |
| Transactions and Stored Procedures |
| Trigger |
| basics |
| Introduction |
| Trigger Basics |
| overview |
| passing values |
| structures |
| Structure of Triggers |
| Structure of User-Defined Functions |
| uses |
| versus constraints |
| versus stored procedures |
| Trigger Basics |
| Triggers vs. Stored Procedures vs. Constraints |
| Typical Uses for Triggers |
| U |
| User Defined Scalar Functions |
| User-Defined Scalar Function Security |
| Using FairCom DB SQL Java Classes |
| Using Java Stored Procedures |
| Trigger Basics |
| Using Java Stored Procedures |
| Using Triggers |
| Using User-Defined Scalar Functions |
| V |
| Visual Studio .NET Development |
| W |
| What Is a Java Snippet? |
| With Constants |
| With Constants and Column References |
| With parameter reference (ODBC/JDBC) |
| Writing Stored Procedures |