| A |
| Aggregate functions |
| NULL values |
| ALLOCATE DESCRIPTOR |
| Application development |
| Array Fetches |
| Associating a Cursor with a Query |
| B |
| BEGIN-END DECLARE SECTION |
| BIGINT data type |
| BINARY data type |
| BIT data type |
| C |
| C programs using ESQL |
| Candidate Keys |
| CHARACTER data type |
| Check constraints |
| CLOSE |
| Closing a Cursor |
| Coding guidelines |
| Column-level candidate key constraint |
| Column-level check constraints |
| Column-level foreign key constraint |
| Column-level primary key constraint |
| Command |
| ESQL |
| ESQL example commands |
| ESQL syntax |
| COMMIT WORK |
| The COMMIT WORK and ROLLBACK WORK Statements |
| The COMMIT WORK Statement |
| Compiling, ESQL |
| Computations, ESQL |
| Condition evaluation, ESQL |
| CONNECT |
| example |
| Connecting to a remote database |
| Connection management |
| Connection name |
| Creating Indices |
| Creating tables |
| Creating tables in cycles |
| Creating views |
| Cursors |
| associating with a query |
| closing |
| Closing a Cursor |
| Closing a Cursor |
| fetching rows |
| opening |
| Opening a Cursor |
| Opening a Cursor |
| retrieving |
| D |
| Data comparison |
| using arithmetic expressions |
| using dh_compare_data |
| Data conversion |
| implicit |
| using dh_conv_data |
| using scalar functions |
| Data type handling, ESQL |
| Data types |
| BIGINT |
| BINARY |
| BIT |
| CHARACTER |
| DATE |
| DECIMAL |
| DOUBLE PRECISION |
| FLOAT |
| INTEGER |
| LVARBINARY (not supported) |
| NUMERIC |
| NUMERIC internal storage format |
| REAL |
| SMALLINT |
| TIME |
| TIMESTAMP |
| Data types, ESQL |
| Database types |
| DATE data type |
| DCL statements |
| DDL statements |
| examples |
| Introduction |
| long running transactions |
| Types of Executable Statements |
| DEALLOCATE DESCRIPTOR |
| DECIMAL data type |
| DECLARE CURSOR |
| Declare section limitations |
| Declare statements in ESQL |
| example |
| Deleting rows in tables |
| DESCRIBE |
| DESCRIBE |
| The DESCRIBE Statement |
| dh_compare_data |
| dh_compare_data |
| Using the SQL API Function tpe_compare_data for Data Comparison |
| dh_conv_data |
| dh_conv_data |
| Using the SQL API Function tpe_conv_data for Data Type Conversion |
| dh_dayofweek |
| dh_get_curdbhdl |
| dh_get_curtmhdl |
| dh_num_add |
| dh_set_cursor |
| dh_set_ptrs |
| dh_set_sqlda |
| dh_sqlallocdesc |
| dh_sqlclose |
| dh_sqlcolumns |
| dh_sqlconnect |
| dh_sqldeallocdesc |
| dh_sqldeclare |
| dh_sqldescribe |
| dh_sqldescribe_param |
| dh_sqldisconnect |
| dh_sqlexecute |
| dh_sqlfetch |
| dh_sqlforeignkeys |
| dh_sqlgetdata |
| dh_sqlgetdesc |
| dh_sqlgetdiag |
| dh_sqlgetsqldaptr |
| dh_sqlopen |
| dh_sqlprepare |
| dh_sqlprimarykeys |
| dh_sqlputdata |
| dh_sqlselect |
| dh_sqlsetdesc |
| dh_sqlstatistics |
| dh_sqltables |
| dh_tm_alloc_handle |
| dh_tm_begin_trans |
| dh_tm_end_trans |
| dh_tm_mark_abort |
| dh_tm_set_level |
| DISCONNECT |
| example |
| DML statement host variables |
| DML statements |
| Introduction |
| types of |
| Types of Executable Statements |
| DOUBLE PRECISION data type |
| Dropping indices |
| Dropping tables |
| Dropping tables in cycles |
| Dropping views |
| Dynamic non-SELECT statements |
| Dynamic SELECT statements |
| E |
| END DECLARE SECTION |
| Error checking |
| SQLCA |
| Error handling |
| indicator variables |
| SQLCA |
| WHENEVER statement |
| ESQL |
| abnormal termination |
| advantages |
| application development |
| command |
| command examples |
| compiling |
| compiling, running |
| Compiling and Running |
| Compiling and Running |
| Compiling and Running |
| Compiling and Running |
| components |
| computation |
| condition evaluation |
| connection management |
| data comparison |
| data conversion |
| data type |
| data type handling |
| declare section limitations |
| declare statements definition |
| declare statements example |
| DML |
| error handling |
| executable statement definition |
| executable statement examples |
| host program development |
| host variables |
| implicit data conversion |
| indicator variables, definition |
| indicator variables, using |
| null value handling |
| overview |
| precompile |
| precompiling |
| program structure |
| sample programs |
| scalar functions |
| SQL management |
| SQL statements |
| statement types |
| status codes |
| syntax |
| transaction management |
| types of executable statements |
| ESQL descriptor statement |
| EXEC |
| Executable statement types |
| Executable statements in ESQL |
| examples |
| Executable statements, ESQL |
| EXECUTE |
| EXECUTE IMMEDIATE |
| EXECUTE IMMEDIATE |
| The EXECUTE IMMEDIATE Statement |
| F |
| FETCH |
| Fetches |
| arrays |
| SQLDA array fetches |
| using a cursor |
| FLOAT data types |
| Functions |
| NVL |
| scalar |
| G |
| GET DESCRIPTOR |
| GROUP BY clause NULL values |
| H |
| Host language types |
| Host variables |
| in DML statements |
| I |
| IN predicate |
| Indicator variables |
| definition |
| error handling |
| insert NULL values |
| retrieve NULL value |
| using |
| Indices |
| creating/dropping |
| Input host variables |
| in query statements |
| Input variables |
| SQLDA |
| Inserting NULL values |
| Inserting rows in tables |
| Inserting rows in tables in cycles |
| INTEGER data type |
| Integrity constraints |
| check constraints |
| column-level candidate key constraints |
| column-level check constraint |
| column-level foreign key constraints |
| column-level primary key constraints |
| table-level candidate key constraints |
| table-level check constraints |
| table-level foreign key constraints |
| table-level primary key constraints |
| types of |
| Isolation levels |
| K |
| Keys |
| candidate |
| primary |
| L |
| LIKE predicate |
| Long data type support |
| Long running transactions |
| LVARBINARY data type (not supported) |
| M |
| Multiple row queries |
| N |
| non-SELECT |
| NULL values |
| in aggregate functions |
| in expressions |
| in GROUP BY clause |
| in ORDER BY clause |
| in scalar functions |
| in WHERE clause |
| inserting |
| retrieving |
| updating |
| NUMERIC data type |
| internal storage format |
| NVL function |
| O |
| OPEN |
| OPEN |
| Opening a Cursor |
| Opening a cursor |
| ORDER BY clause NULL values |
| Output host variables |
| in query statements |
| Output variables |
| SQLDA |
| Overview of ESQL |
| P |
| Precompiling, ESQL |
| Predicates |
| IN |
| LIKE |
| PREPARE |
| PREPARE |
| Preparing Statements |
| Primary keys |
| Programmatic Interfaces |
| Q |
| Queries |
| multiple row |
| single row |
| Query Expressions |
| Query statements |
| R |
| REAL data type |
| Record types |
| Referential constraints |
| Referential integrity |
| Relational views |
| Retrieving a cursor |
| Retrieving NULL values |
| Rollback transaction |
| ROLLBACK WORK |
| The COMMIT WORK and ROLLBACK WORK Statements |
| The ROLLBACK WORK Statement |
| S |
| Sample ESQL programs |
| Scalar functions |
| data type conversions |
| NULL values |
| NVL |
| Search Conditions |
| SELECT |
| SET CONNECTION |
| example |
| SET DESCRIPTOR |
| SINGLE-ROW SELECT |
| SMALLINT data type |
| SQL |
| Management |
| queries |
| statements |
| SQL communication area |
| SQLCODE |
| SQLWARN |
| SQL Descriptor Area |
| allocating |
| array fetches |
| components |
| diagram |
| fields |
| freeing |
| input variables |
| output variables |
| types and lengths |
| SQL in a host language |
| SQL statement input host variables |
| SQL statement output host variables |
| SQL statements |
| BEGIN-END DECLARE SECTION |
| CLOSE |
| DECLARE CURSOR |
| DESCRIBE |
| END DECLARE SECTION |
| EXEC SQL |
| EXECUTE |
| EXECUTE IMMEDIATE |
| FETCH |
| OPEN |
| PREPARE |
| QUERY EXPRESSIONS |
| SEARCH CONDITIONS |
| SINGLE-ROW SELECT |
| TYPE DECLARATIONS |
| TYPE SPECIFICATIONS |
| WHENEVER |
| SQL_NOT_FOUND |
| SQLCA |
| error checking |
| error handling |
| SQLCODE |
| SQLWARN |
| warning checking |
| SQLCODE |
| sqld_alloc |
| sqld_free |
| SQLDA |
| allocating |
| array fetches |
| components |
| diagram |
| fields |
| freeing |
| input variables |
| output variables |
| types and lengths |
| SQLWARN |
| Statements |
| BEGIN-END DECLARE SECTION |
| CLOSE |
| COMMIT WORK |
| The COMMIT WORK and ROLLBACK WORK Statements |
| The COMMIT WORK Statement |
| CONNECT |
| CONNECT, example |
| DDL |
| DECLARE CURSOR |
| DESCRIBE |
| DESCRIBE |
| The DESCRIBE Statement |
| DISCONNECT |
| DISCONNECT, example |
| DML |
| dynamic non-SELECT |
| dynamic SELECT |
| END DECLARE SECTION |
| EXEC SQL |
| EXECUTE |
| EXECUTE IMMEDIATE |
| EXECUTE IMMEDIATE |
| The EXECUTE IMMEDIATE Statement |
| FETCH |
| non-SELECT |
| OPEN |
| OPEN |
| Opening a Cursor |
| PREPARE |
| PREPARE |
| Preparing Statements |
| QUERY EXPRESSIONS |
| ROLLBACK WORK |
| SEARCH CONDITIONS |
| SELECT |
| SET CONNECTION |
| SET CONNECTION, example |
| SINGLE-ROW SELECT |
| SQL SELECT |
| static non-SELECT |
| static SELECT |
| TYPE DECLARATIONS |
| TYPE SPECIFICATIONS |
| WHENEVER |
| Using the WHENEVER Statement for Error Handling |
| WHENEVER |
| Static array types |
| Static non-SELECT statements |
| Static SELECT statements |
| Syntax, ESQL |
| T |
| Table record types |
| Table-column types |
| Table-level candidate key constraint |
| Table-level check constraint |
| Table-level foreign key constraint |
| Table-level primary key constraint |
| Tables |
| creating in cycles |
| creating/dropping |
| deleting rows |
| dropping in cycles |
| inserting rows |
| inserting rows in cycles |
| updating rows |
| TIME data type |
| TIMESTAMP data type |
| Transaction management |
| forced rollback |
| isolation levels |
| locking |
| statements |
| Transactions |
| long running |
| TYPE DECLARATIONS |
| TYPE SPECIFICATIONS |
| Types of ESQL executable statements |
| U |
| Updating NULL values |
| Updating rows in tables |
| Using NULL Values |
| V |
| Variables |
| indicator |
| input host |
| Input Host Variables in DML Statements |
| Input Host Variables in Query Statements |
| output host |
| Views |
| creating/dropping |
| W |
| Warning checking |
| SQLCA |
| WHENEVER |
| WHERE clause NULL values |