Index

A

access mode settings (transactions) 7.5.2
alternative environments, support 8.4
applets, using SQLJ 2.6.1
arrays
- as iterator columns 5.1.2
- VARRAYs 6.1.3
assignment statements (SET) 4.6
assumptions, environment 1.1.1
AuditorInstaller
- command-line examples A.6.5
- customizer for debugging A.6
- invoking A.6.2
- options A.6.4
- runtime output A.6.3
auditors in profiles for debugging A.6.1
auto-commit
- modifying in existing connection 3.5.4
- specifying in new connection 3.5.3

B

backup option (customizer harness) A.3.2.1
backward compatibility
- Oracle SQLJ, general 1.1.5
- to Oracle8i 5.1.4
batch updates
- batchable and compatible statements 10.1.3
- batching incompatible statements 10.1.3
- batch limit 10.1.3
- canceling a batch 10.1.3
- cautions 10.1.3
- enabling and disabling 10.1.3
- error conditions during execution 10.1.3
- explicit and implicit batch execution 10.1.3
- overview 10.1.3
- update counts 10.1.3
- using implicit execution contexts 10.1.3
- with respect to recursive call-ins 10.1.3
BetterDate (custom Java class) 6.2.6
BFILEs
- as stored function results 5.3.2
- BFILE support 5.3.2
BigDecimal
- support 5.3.6
binary portability of profiles 3.8.3.2
bind-by-identifier option (sqlj -bind-by-identifier) 8.3.2
BLOB support 5.3.2
BOOLEAN type (PL/SQL) 5.1.3

C

D

E

echoing command line without executing 8.1.2
echo option, without execution 8.2.1
encoding
- character encoding for messages 9.4.2
- character encoding for source 9.4.2
- command line example 9.4.2
- do not pass option to compiler 8.4.1
- overview of character encoding 9.4.1
- setting at runtime 9.4.4
- using native2ascii 9.4.4
encoding option, source files (sqlj -encoding) 8.2.2
environment assumptions and requirements 1.1
environments--scenarios and limitations 1.1.3
environment variable, translator options 8.1.4
errors
- character encoding for messages 9.4.2
- customization messages A.2.4
- messages, codes, and SQL states 3.4.2
- outputting cause and action 8.2.4
- runtime categories 9.3.2
- translator error, warning, info messages 9.2.1
exceptions
- exception-handling requirements 3.4.1
- processing 3.4.2
- set up exception-handling 3.6
- using SQLException subclasses 3.4.3
executable statements
- examples 4.2.4
- overview 4.2
- rules 4.2.1
- specifying connection/execution contexts 4.2.3
- SQLJ clauses 4.2.2
- using PL/SQL blocks 4.2.5
execution contexts
- cancellation method 7.2.4.3
- close() method 7.2.4.6
- control methods 7.2.4.2
- creating and specifying 7.2.2
- method usage, example 7.2.4.7
- overview 7.2
- relation to connection contexts 7.2.1
- relation to multithreading 7.2.5
- savepoint methods 7.2.4.5
- specifying for executable statement 4.2.3
- status methods 7.2.4.1
- synchronization 7.2.3
- update-batching methods 7.2.4.4
exemplar schema 3.2.6
exit codes, translator 9.2.3
explain option (sqlj -explain) 8.2.4
extending iterator classes 7.4.3
extensions
- overview 2.3
- performance extensions 10.1
- summary of features used A.3.6.10
- type extensions 5.3

F

FETCH CURRENT syntax (iterators) 7.4.5
file name requirements and restrictions 3.10.4
fixedchar option (Oracle customizer) A.3.6.7
fixedchar option (SQLJ -fixedchar) 8.2.6
flags for special processing 8.3.2
force option (Oracle customizer) A.3.6.3
function calls, stored 4.7.2

G

getConnection() method (Oracle class) 3.2.4
globalization support
- character encoding, language support 9.4.1
- outside of SQLJ 9.4.4
- overview 2.7.1
- related data types 5.1.1
- related Java types 9.4.3
- related SQLJ and Java settings 9.4.2
- support for Unicode characters 9.4.3

H

help option (customizer harness) A.3.2.5
help options (sqlj -help-xxxx) 8.2.1
hints in code, parameter sizes 10.1.5
host expressions
- basic syntax 4.3.2
- bind by identifier 8.3.2
- evaluation at runtime 4.3.5
- examples 4.3.3
- examples of evaluation at runtime 4.3.6
- iterators and result sets as host variables 4.5.6
- overview 4.3.1
- restrictions 4.3.7
- selecting a nested table 6.5.3
- supported types for JDBC 2.0 5.1.2
- type support for Oracle8i 5.1.4
- type support summary 5.1.1
host variables 2.4.1

I

IDE SQLJ integration 2.7.2
IMPLEMENTS clause
- in connection context declarations 7.1.6
- in iterator declarations 7.4.2
- syntax 4.1.4
importing required classes 3.6
informational messages, translator 9.2.1
input to translator 2.4.2
installation and configuration verification 1.2
instrumenting class file (linemap) 8.2.4
instrument option (sqlj -instrument) 8.2.5
interoperability with JDBC
- connection contexts and connections 7.6.1
- iterators and result sets 7.6.2
isolation level settings (transactions) 7.5.3
iterators
- accessing named iterators 4.5.4
- accessing positional iterators 4.5.5
- array columns 5.1.2
- as host variables 4.5.6
- as iterator columns (nested) 4.5.7
- as stored function returns 4.7.3
- commit/rollback effect 3.5.6
- concepts 4.5.1
- converting from result sets 7.6.2
- converting to result sets 7.6.2
- declarations 4.1.2
- declaring named iterators 4.5.4
- declaring positional iterators 4.5.5
- declaring with IMPLEMENTS clause 7.4.2
- extending 7.4.3
- general steps in using 4.5.2
- instantiating/populating named iterators 4.5.4
- instantiating/populating positional iterators 4.5.5
- iterator class functionality 7.4.1
- named vs. positional 4.5.3
- nested iterators for nested tables 6.5.5
- overview 4.5
- positional iterators, using next() 4.5.5
- result set iterators (strongly typed) 4.5.1.1
- result set iterators (weakly typed) 4.5.1.2, 7.4.4
- scrollable 7.4.5
- scrollable result set iterators 7.4.5
- selecting objects and references 6.4.1
- set up named iterator (example) 3.6
- subclassing 7.4.3
- using named iterators 4.5.4
- using positional iterators 4.5.5
- using weakly typed iterators 7.6.2
- with serialized objects 6.6.3

J

jar file digests option, customization A.3.2.4
jar files for profiles A.4
JavaBeans for SQLJ connections 7.1.10
Java bind expressions (dynamic SQL) 7.7.1
javac compatibility 8.1.1
Java properties, getProperty() 9.4.4
Java VM
- classpath option 8.2.1
- options through SQLJ 8.3.1
- specifying name 8.4.1
JDBC 2.0
- support for LOB types 5.3
- support for weakly typed Struct, Ref, Array 6.7
- types supported 5.1.2
JDBC connection methods (transactions) 7.5.4
JDBC driver registration option (sqlj -driver) 8.2.3
JDBC drivers
- Oracle drivers 3.1.1
- select/register for customization A.3.3.4
- select/register for runtime 3.1.3
- select for translation 3.1.2
- verify 1.3.3
JDBC interoperability
- connection contexts and connections 7.6.1
- iterators and result sets 7.6.2
JDBC vs. SQLJ, sample application 2.5
jdblinemap option (sqlj -jdblinemap) 8.2.4
JDeveloper
- debugging with 10.2.3
- SQLJ integration 2.7.2
JDK
- supported versions 1.1.3
JNDI
- name of default data source 7.1.8
- use for data sources, connections 7.1.8
J prefix (sqlj -J-x) 8.3.1

K

KEEP_CONNECTION 7.6.1

L

language support (globalization support) 9.4.1
linemap option (sqlj -linemap) 8.2.4
line-mapping
- SQLJ source to class file 8.2.4
- SQLJ source to class for jdb 8.2.4
loadjava
- compatibility options, SQLJ 8.1.1
LOBs
- as iterator columns 5.3.2
- as stored function results 5.3.2
- FETCH INTO LOB host variables 5.3.2
- SELECT INTO LOB host variables 5.3.2
- support (oracle.sql and DBMS_LOB) 5.3.2
locale
- command line example 9.4.2
- for messages 9.4.2
- setting at runtime 9.4.4
log option (AuditorInstaller) A.6.4.2

M

message pipe, compiler 8.4.1
meta bind expressions (dynamic SQL) 7.7.1
method support for objects 6.2.2
middle-tier considerations 3.11
multithreading
- in SQLJ, overview 7.3
- relation to execution contexts 7.2.5
- sample application 7.3

N

named iterators
- accessing 4.5.4
- declaring 4.5.4
- instantiating and populating 4.5.4
- scrollable 7.4.5
- using 4.5.4
name of compiler 8.4.1
name of Java VM 8.4.1
naming requirements and restrictions
- file names 3.10.4
- local variables, classes (Java namespace) 3.10.1
- SQLJ namespace 3.10.2
- SQL namespace 3.10.3
native2ascii for encoding 9.4.4
NcharAsciiStream class (globalization support) 9.4.3
NCHAR class (globalization support) 9.4.3
NcharUnicodeStream class (globalization support) 9.4.3
NCLOB class (globalization support) 9.4.3
nested iterators 6.5.5
nested tables
- accessing 6.5.1
- inserting in SQLJ 6.5.2
- manipulating 6.5.4
- selecting into host expression 6.5.3
- types 6.1.3
- using nested iterator 6.5.5
non-repeatable reads 7.5.3
n option (sqlj -n) (echo without execution) 8.2.1
NString class 9.4.3
NString class (globalization support) 9.4.3
null-handling
- examples 3.3.2
- wrapper classes for null-handling 3.3.1

O

P

parameter definitions (sizes)
- general information 10.1.5
- Oracle customizer optparamdefaults option A.3.6.6
- Oracle customizer optparams option A.3.6.5
- SQLJ -optparamdefaults option 8.2.6
- SQLJ -optparams option 8.2.6
parse option (sqlj -parse) 8.3.3
passes, two-pass compiling 8.4.1
passes option (sqlj -passes) 8.4.1
passing options to other executables 8.3.1
password option (customizer harness) A.3.3.2
password option for checking (sqlj) 8.2.3
path and classpath 1.2.3
performance enhancements 10.1
performance monitoring, DMS support 10.3
phantom reads 7.5.3
pipe, compiler output messages 8.4.1
PL/SQL
- blocks in executable statements 4.2.5
- BOOLEAN type 5.1.3
- RECORD type 5.1.3
- TABLE type 5.1.3
plan baselines 7.9
- command-line options 7.9.2
- generated Java file 7.9.5
- generated log file 7.9.4
- generated SQL file 7.9.3
- property file options 7.9.2
positional iterators
- accessing 4.5.5
- declaring 4.5.5
- instantiating and populating 4.5.5
- navigation with next() 4.5.5
- scrollable 7.4.5
- using 4.5.5
positioned delete 5.3.3
positioned update 5.3.3
P prefix (sqlj -P-x) 8.3.1
prefetching rows 10.1.1
prefixes
- to pass options to customizer 8.3.1
- to pass options to Java compiler 8.3.1
- to pass options to Java VM 8.3.1
prefix option (AuditorInstaller) A.6.4.3
print option (customizer harness) A.3.4.2
procedure calls, stored 4.7.1
profile customization (see customization) 9.1.5
profile-keys 3.8.5.2
profile-keys class 3.8.4, 9.1.3
profile option (sqlj -profile) 8.3.2
profiles
- auditors for debugging A.6.1
- binary portability 3.8.3.2
- code layers A.6.1
- creation during code generation A.1.1
- debug option A.3.4.1
- functionality at runtime A.2.5
- generated profiles 9.1.3
- more about profiles A.1
- overview 3.8.3
- print option A.3.4.2
- sample profile entry A.1.2
- use of jar files A.4
- verify option A.3.4.3
properties, Java, getProperty() 9.4.4
properties files, SQLJ DMS 10.3.3
properties files (translator)
- default properties files 8.1.3
- overview 8.1.3
- setting input file 8.2.1
- syntax 8.1.3
props option (sqlj -props) 8.2.1
public class name / source name check 8.4.1

R

READ COMMITTED transactions 7.5.3
READ ONLY transactions 7.5.2
READ UNCOMMITTED transactions 7.5.3
READ WRITE transactions 7.5.2
RECORD type (PL/SQL) 5.1.3
REF CURSOR
- about REF CURSOR types 5.3.4
- example 5.3.4
- SQLJ support 5.3.4
registering column types/sizes 10.1.4
registering parameter sizes 10.1.5
register JDBC drivers
- for runtime 3.1.3
- for translation 8.2.3
REPEATABLE READ transactions 7.5.3
reporting options (translator) 8.2.4
requirements, environment 1.1.2
result expressions
- evaluation at runtime 4.3.5
- overview 4.3.4
result set iterators (strongly typed)
- Overview 4.5.1.1
result set iterators (weakly typed)
- general information 7.4.4
- Overview 4.5.1.2
- scrollable 7.4.5
ResultSetIterator type 7.4.4
result sets
- as host variables 4.5.6
- as iterator columns 4.5.7
- as stored function returns 4.7.3
- commit/rollback effect 3.5.6
- converting from iterators 7.6.2
- converting to iterators 7.6.2
returnability (cursor states, WITH clause) 4.1.5.3
rollback
- effect on iterators and result sets 3.5.6
- manual 3.5.5
- with savepoint 3.5.7
ROWID
- as stored function results 5.3.3
- FETCH INTO ROWID host variable 5.3.3
- SELECT INTO ROWID host variable 5.3.3
- support 5.3.3
row prefetching 10.1.1
runtime
- categories of errors 9.3.2
- debugging output (AuditorInstaller) A.6.3
- functionality 9.3
- functionality of profiles A.2.5
- generated calls to runtime 9.1.3
- globalization support 9.4
- JDBC driver selection and registration 3.1.3
- overview 2.2.2, 3.8.2
- packages 9.3.1
- set up connection 1.3.1
- steps in runtime processing 2.4.3
- test 1.3.4

S

T

TABLE syntax (nested tables) 6.5.1, 6.5.4
TABLE type (PL/SQL) 5.1.3
Thin driver (JDBC) 3.1.1
transactions
- access mode settings 7.5.2
- advanced transaction control 7.5
- automatic commit vs. manual commit 3.5.2
- basic transaction control 3.5
- isolation level settings 7.5.3
- JDBC Connection methods 7.5.4
- manual commit and rollback 3.5.5
- modifying auto-commit 3.5.4
- overview 3.5.1
- savepoints for rollbacks 3.5.7
- specifying auto-commit 3.5.3
translator
- basic translation steps 2.4.1
- code generation 9.1.3
- compilation 9.1.4
- customization 9.1.5
- error, warning, info messages 9.2.1
- exit codes 9.2.3
- globalization support 9.4
- input and output 2.4.2
- internal operations 9.1
- Java and SQLJ code-parsing, syntax-checking 9.1.1
- overview 2.2.1, 3.8.2
- SQL semantics-checking and offline parsing 9.1.2
- status messages 9.2.2
- support for alternative environments 8.4
- test 1.3.4
type extensions 5.3
type resolution, expand search 8.3.2
types supported
- for JDBC 2.0 5.1.2
- for Oracle8i 5.1.4
- summary of types 5.1.1

U

uninstall option (AuditorInstaller) A.6.4.6
update batching
- batchable and compatible statements 10.1.3
- batching incompatible statements 10.1.3
- batch limit 10.1.3
- canceling a batch 10.1.3
- cautions 10.1.3
- enabling and disabling 10.1.3
- error conditions during execution 10.1.3
- explicit and implicit batch execution 10.1.3
- overview 10.1.3
- update counts 10.1.3
- using implicit execution contexts 10.1.3
- with respect to recursive call-ins 10.1.3
URL, database
- default prefix for online checking 8.2.3
- SIDs deprecated 1.3.1
- use of database service names 1.3.1
url option (customizer harness) A.3.3.3
url option for checking (sqlj -url) 8.2.3
user-defined types 6.3
user option (customizer harness) A.3.3.1
user option for checking (sqlj -user) 8.2.3

V

VALUES syntax for stored functions 4.7.2
VARRAYs
- inserting a row 6.5.7
- selecting into host expression 6.5.6
- VARRAY types 6.1.3
verbose option (customizer harness) A.3.2.6
verify option (customizer harness) A.3.4.3
version compatibility (Oracle customizer) A.3.6.2
version number options (sqlj -version-xxxx) 8.2.1
VM
- classpath option 8.2.1
- options through SQLJ 8.3.1
- specifying name 8.4.1
vm option (sqlj -vm) 8.4.1

W

warning messages, translator 9.2.1
warnings, translator, enabling/disabling 8.2.4
warn option (SQLCheckerCustomizer) A.5.2.2
warn option (sqlj -warn) 8.2.4
weakly typed custom Java classes 6.1.1
weakly typed iterators 7.4.4
weak object/collection types
- restrictions 6.7.2
- support 6.7.1
WHERE CURRENT OF 5.3.3
WHERE CURRENT OF clause 5.3.3
Windows, SQLJ development in 2.7.3
WITH clause syntax 4.1.5
wrapper classes for null-handling 3.3.1