INFORMIX
IBM Informix Embedded SQLJ User's Guide
Index
Contents

Index

A

Accessor methods 3-7, 4-4, 4-8

B

BEGIN DECLARE SECTION statement 4-3
BEGIN...END block 4-4
Binding of variables 1-5
Boldface type Intro-6
Boolean options 5-11

C

-C prefix 5-11
-cache option 5-8
.class files 1-4
CLASSPATH environment variable 2-5, 3-4, 5-4
close() method 4-10
Column aliases 4-10
Command options, ifxsqlj 5-5
Comment icons Intro-7
-compile option 5-8
-compiler-encoding-flag option 5-8
-compiler-executable option 5-8
-compiler-output-file option 5-8
Compiling code 5-3
Compliance
with industry standards Intro-9
Connecting to a database 3-3
Connection-context class A-4
Connection-context object A-4
ConnectionManager class 3-3, 3-8, A-1
ConnectionManager.java file 3-4
Contact information Intro-9
Curly braces, {} 4-5
Cursors 3-6, 4-3

D

-d option 5-6
Database
names, setting in database URLs A-3
Database server names, setting in database URLs A-3
Database servers 2-3
Database URLs 3-3, A-2
Databases, connecting to 3-3
Default connection context 1-5, 3-4
Deletes, positioned 4-11
Demo01.sqlj program B-1
Demo02.sqlj program B-1
Demo03.sqlj program 3-8, B-1
Demo04.sqlj program B-1
Demo05.sqlj program B-1
Demo06.sqlj program B-1
demoUtil.java program A-4
Dependencies, software Intro-5
-dir option 5-6
Documentation notes Intro-8
Documentation, types of Intro-8
Domain names, setting in database URLs A-3
-driver option 5-8
Dynamic SQL 4-4

E

Embedded SQL, traditional 4-3
-encoding option 5-6
END DECLARE SECTION statement 4-3
endFetch() method 4-10
Environment variables Intro-6
Errors 4-17
ESQL/C 4-3
EXECUTE FUNCTION statement 4-4, 4-12
EXECUTE PROCEDURE statement 4-4, 4-12
Execution context 4-11

F

FETCH statement 3-6, 4-4, 4-5, 4-7
Files
ConnectionManager.java 3-4
ifxjdbc.jar 5-4
ifxsqlj-g.jar 2-4
ifxsqlj.jar 2-4, 5-4
ifxtools.jar 2-4, 5-4
iterator_name.class 5-3
java.properties 4-15
profilekeys.class 5-3
Property files 5-12
setup.class 2-4
SQLChecker.cache 5-8
sqlj.properties 5-12
.ser 5-3, 5-9, 5-15
file.encoding property 4-15, 5-6
Functions 4-12

G

getExecutionContext() method 4-11
getMaxFieldSize() method 4-12
getMaxRows() method 4-12
getQueryTimeout() method 4-12
getSQLWarnings() method 4-12
getUpdateCount() method 4-12
GLS 5-6

H

-help option 5-6
Host variables 3-5, 4-3, 4-5

I

ifxjdbc.jar file 5-4
ifxprofp tool 5-15
ifxsqlj command 5-3
ifxsqlj-g.jar file 2-4
ifxsqlj.jar file 2-4, 5-4
ifxtools.jar file 2-4, 5-4
Important paragraphs, icon for Intro-7
Informix database servers 2-3
Informix JDBC Driver 1-4, 2-3, 2-4, A-2
INFORMIXSERVER environment variable A-3
initContext() method 3-4, 3-8, A-1
Internal resource files
Files
Internal resource files 5-3
IP addresses, setting in database URLs A-3
isClosed() method 4-10
Iterator objects 3-6, 3-8, 4-3, 4-6
iterator_name.class file 5-3

J

-J prefix 5-11
Java compiler 1-4
Java Development Kit (JDK) 2-3, 2-4
Java interpreter 5-4
Java types 4-13
java.properties file 4-15
JDBC 1-3, 1-5, 4-15, 5-8, 5-10

L

Language character sets 4-15
Latin-1 character set 4-15
Line numbers 5-6
-linemap option 5-6

M

main() method 3-8
MultiConnect.sqlj program A-4
Multiple database connections 4-3

N

Named iterators 3-6, 4-8
Name-value pairs of database URLs A-3
native2ascii tool 4-15
newConnection() method A-1
next() method 4-9, 4-10
Nondefault connections A-4
Null data 4-4
Null indicator variables 4-15

O

Off-line checking 5-14
-offline option 5-9
On-line checking 5-9, 5-10, 5-13
-online option 5-9
Output directory 5-6

P

-password option 5-9
Passwords, setting in database URLs A-3
PATH environment variable 5-8
Platform icons Intro-7
Port numbers, setting in database URLs A-3
Positional iterators 3-6, 4-7
Positioned updates, deletes 4-11
Preprocessing source code 5-3
profilekeys.class file 5-3
Property files 5-12
-props option 5-7, 5-12

R

README file 2-5, B-1
Related reading Intro-8
Release notes Intro-8
Reserved names 4-16
Result sets 3-6, 4-6
Root output directory 5-6
rowCount() method 4-10
Running Embedded SQLJ programs 5-3

S

Sample programs 2-5, 3-8, B-1
Schema checking 1-5
SELECT statement 3-6
SELECT...AS statement 4-10
SELECT...INTO statement 3-5, 4-5, 4-6
Semantics checking 1-5, 5-14
.ser files 5-3, 5-9, 5-15
-ser2class option 5-9
Servers 2-3
setMaxFieldSize() method 4-12
setMaxRows() method 4-12
setQueryTimeou() method 4-12
setSQLWarnings() method 4-12
setUpdateCount() method 4-12
setup.class file 2-4
__sJT prefix 4-16
Software dependencies Intro-5
Specifying environment variables A-3
SPL routines 4-12
SQL statements 3-5, 4-5
SQL types 4-13
SQL92 Entry level 4-4
SQLChecker.cache file 5-8
SQLException class 4-15
SQLException methods 4-17
SQLJ consortium 1-3
.sqlj file extension 4-4
SQLJ runtime package 4-15
SQLJ stream types 4-15
SQLJ translator 1-3, 4-16, 5-3
sqlj.properties file 5-12
sqlj.semantics.JdbcChecker class 5-9
sqlj.semantics.OfflineChecker class 5-9
-status option 5-7
Stored functions 4-12
Syntax checking 1-5, 5-14
System requirements Intro-5

T

Tip icons Intro-7
Translating source code 5-3
Type checking 1-5, 4-8, 4-9
Type mappings 4-13

U

Unicode escape sequences 4-15
Updates, positioned 4-11
-url option 5-10
User names, setting in database URLs A-3
-user option 5-10

V

-version option 5-7
-vm option 5-10

W

-warn option 5-7
Warning icons Intro-7
WHENEVER...GOTO/CONTINUE statement 4-3
WHERE CURRENT OF clause 4-11



IBM Informix Embedded SQLJ User's Guide, Version 1.0
Copyright © 1999, IBM Corporation. All rights reserved.