RELEASE(COMMIT)
RELEASE(DEALLOCATE)
SQLERROR(NOPACKAGE)
SQLERROR(CONTINUE)
VALIDATE(RUN)
VALIDATE(BIND)
Notes:
1 These options can be specified in any order.
DB2 Database for Linux, UNIX, and Windows options
(1) BLOCKING UNAMBIG
BLOCKING ALL
BLOCKING NO
DEC 15
DEC 31
DEGREE 1
DEGREE ANY
EXPLAIN NO
EXPLAIN YES
EXPLSNAP NO
EXPLSNAP ALL
EXPLSNAP YES
FEDERATED NO
FEDERATED YES
FUNCPATH schema-name
INSERT DEF
INSERT BUF
ISOLATION CS
ISOLATION RR
ISOLATION RS
ISOLATION UR
OWNER authorization-ID QUALIFIER qualifier-name QUERYOPT optimization-level
SQLERROR NOPACKAGE
SQLERROR CONTINUE
SQLWARN YES
SQLWARN NO
STATICREADONLY NO
STATICREADONLY YES
VALIDATE RUN
VALIDATE BIND
Notes:
1 These options can be specified in any order.
Command parameters
-help
Specifies that db2sqljbind describes each of the options that it supports. If any
other options are specified with -help, they are ignored.
-url
Specifies the URL for the data source for which the profile is to be customized.
A connection is established to the data source that this URL represents if the
-automaticbind or -onlinecheck option is specified as YES or defaults to YES.
The variable parts of the -url value are:
server
The domain name or IP address of the operating system on which the
database server resides.
port
The TCP/IP server port number that is assigned to the database server.
The default is 446.
database
A name for the database server for which the profile is to be customized.
If the connection is to a DB2 for z/OS server, database is the DB2 location
name that is defined during installation. All characters in this value must
be uppercase characters. You can determine the location name by executing
the following SQL statement on the server:
Chapter 7. JDBC and SQLJ reference information 409
To Next Page
Loading...
Need help?
General