Property |
AS/400 Toolbox for Java JDBC Support |
Native JDBC Support |
Description |
user |
X |
X |
User name for connecting to AS/400 |
password |
X |
X |
Password for connecting to AS/400 |
prompt |
X |
|
Specifies whether the user should be prompted if a user name or
password is needed to connect to the AS/400 server |
libraries |
X |
X |
The AS/400 libraries to add to the server's job library list.
For Native, only one library is allowed and it will be used as the
default library |
transaction isolation |
X |
X |
Sets the transaction isolation level for the connection. Has
same affect as using Connection.setTransactionIsolation() |
date format |
X |
|
The date format used in date literals within SQL
statements |
date separator |
X |
|
The date separator used in date literals within SQL
statements |
decimal separator |
X |
|
The decimal separator used in numeric literals within SQL
statements |
do escape processing |
|
X |
Specifies if statements under the connection must do escape
processing. Using escape processing is a way to code your SQL
statements so that they are generic and similar for all platforms,
but then the database reads the escape clauses and substitutes the
proper system specific version for the user |
naming |
X |
X |
The naming convention used when referring to tables (sql versus
system) |
time format |
X |
|
The time format used in time literals within SQL
statements |
time separator |
X |
|
The time separator used in time literals within SQL
statements |
block criteria |
X |
|
The criteria for retrieving data from the AS/400 server in
blocks of records |
block size |
X |
X |
The block size in kilobytes to retrieve from the AS/400 server
and cache on the client |
blocking enabled |
|
X |
Specifies if the connection should use blocking on result set
row retrieval |
lob threshold |
X |
|
Specifies the maximum LOB (large object) size in kilobytes that
can be retrieved as part of a result set |
prefetch |
X |
|
Specifies whether to prefetch data upon executing a SELECT
statement |
extended dynamic |
X |
|
Extended dynamic support provides a mechanism for caching
dynamic SQL statements on the server |
package |
X |
|
Specifies the base name of the SQL package |
package library |
X |
|
Specifies the library for the SQL package |
package criteria |
X |
|
Specifies the type of SQL statements to be stored in the SQL
package |
package cache |
X |
|
Specifies whether to cache SQL packages in memory |
package clear |
X |
|
Specifies whether to clear SQL packages when they become
full |
package add |
X |
|
Specifies whether to add statements to an existing SQL
package |
package error |
X |
|
Specifies the action to take when SQL package errors occur |
sort |
X |
|
Specifies how the server sorts records before sending them to
the client |
sort language |
X |
|
Specifies a three-character language id to use for selection of
a sort sequence |
sort table |
X |
|
Specifies the library and file name of a sort sequence table
stored on the AS/400 server |
sort weight |
X |
|
Specifies how the server treats case while sorting records |
access |
X |
X |
Specifies the level of database access for the connection |
error |
X |
|
Specifies the amount of detail to be returned in the message
for errors that occur on the AS/400 server |
remarks |
X |
|
Specifies the source of the text for REMARKS columns in
ResultSets returned by DatabaseMetaData methods |
secure |
X |
|
Specifies whether a SecureSockets Layer (SSL) connection is
used to communicate with the server |
translate binary |
X |
X |
Specifies whether binary data is translated |
trace |
X |
X |
Specifies whether trace messages should be logged |