Font size:

Index

Index

Index

A

Absolute (ij command) (280)
After Last (ij command) (282)
Async (ij command) (284)
Attributes to database connection URL
- validating in ij (273)
Auto-commit
- turning off (ij) (286)
Autocommit (ij command) (285)

B

Before First (ij command) (287)
Bulk import/export (342)
- and NULL (367)
- before invoking (358)
- CODESET (368)
- description (233)
- examples of (363)
- executing procedures from JDBC (365)
- file format (366)
- not for client/server mode (349)
- overview (345)
- requirements and considerations (350)
- text files (348)

C

Close (ij command) (289)
derby.ui.codeset (tool property) (276)
org.apache.derby.tools.dblook (376)
org.apache.derby.tools.sysinfo (373)
Commit (ij command) (291)
Connect (ij command) (292)
Connection
- switching (ij) (334)
Creating a new database (ij) (293)
derby.jar (239)
dblook
- description (236)
- using (377)
derbytools.jar (238)
Cursors
- fetching next row (ij) (281), (283), (288), (307), (314) , (319), (323), (327)
- using (ij) (290)
- working with (ij) (309), (311)

D

Database class utilities
- description (234)
Database connection URL
- description (242)
- shortcut (ij) (296)
- specifying in ij (260)
- supported protocols within (244), (246), (248)
Disconnect (ij command) (294)
Disconnecting (ij) (295)
Display
- localizing (ij) (316)
Driver (ij command) (297)
Drivers
- overview (241)

E

Elapsed time (ij command) (299)
Escape sequences
- and unicode (339)
Execute (ij command) (301)
Exit (ij command) (303)
Export
- and data types (351)
- and locking (354)
- options for running (346)
- procedure arguments (362)
- procedure definitions (361)
- using (344)

F

First (ij command) (306)

G

Get Cursor (ij command) (308)
Get Scroll Insensitive Cursor (ij command) (310)

H

Help (ij command) (312)

I

ij
- commands (278)
- description (232)
- Java(TM) 2 Platform, Standard Edition requirement (237)
- properties (256), (263)
- semicolon between statements required (261)
- starting (255)
ij (scripting tool)
- using (254)
ij.connection (ij property) (264)
ij.database (ij property) (265)
ij.driver (ij property) (266)
ij.maximumDisplayWidth (ij property) (267)
ij.outfile (ij property) (268)
ij.protocol (ij property) (269)
ij.protocol.protocolName (ij property) (270)
ij.showErrorCode (ij property) (271)
ij.unicodeEscape (ij property) (272)
ij.URLCheck (ij property) (275)
Import
- and data types (352)
- and locking (353)
- and REPLACE option (356)
- behavior on tables with triggers (355)
- options for running (347)
- procedure arguments (360)
- procedure definitions (359)
- restrictions on tables (357)
- using (343)
- with identity columns (364)
Internationalization
- and the DB2 Derby tools (250)
Internationalization features
- codeset (277)

J

jar files
- storing (369)
JDBC
- basics (240)
JDBC driver
- loading (ij command) (298), (300)
- specifying in ij (259)

L

Last (ij command) (313)
Locales
- and the Derby tools (252)
- overview (251)
- types of (253)
LocalizedDisplay (ij command) (315)

M

MaximumDisplayWidth (ij command) (317)
Multiple connections
- displaying (ij) (336)

N

Next (ij command) (318)

P

Prepare (ij command) (320)
Prepared statements
- executing (ij) (302)
- preparing (ij) (321)
- removing (ij) (329)
Previous (ij command) (322)
Protocol (ij command) (324)
Protocols (243), (245), (247), (249)

R

Readonly (ij command) (325)
Relative (ij command) (326)
Remove (ij command) (328)
Rollback (ij command) (330)
Run (ij command) (331)
Running a script (ij) (332)
Running SQL scripts in ij (262)

S

Scripts
- running in ij (279)
Set Connection (ij command) (333)
Show Connections (ij command) (335)
Shutdown
- automatic with ij Exit command in embedded system (304)
Shutting down JBMS (embedded, from ij) (305)
Specifying ij properties (258)
SQLJ.install_jar (370)
SQLJ.remove_jar (371)
SQLJ.replace_jar (372)
Starting ij with a properties file (257)
Strings in ij (341)
sysinfo
- description (235)
- using (374)

T

Tools
- how to use (231)

U

Unicode
- escape sequences (ij) (338)
UnicodeEscape (ij command) (337)
URL attributes
- verifying in ij (274)

V

Version
- verifying (375)

W

Wait For (ij command) (340)

Previous Page
Table of Contents
Index