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 the SQLJ customizer describes each of the options that the
customizer 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 z/OS system on which the DB2
subsystem resides.
port
The TCP/IP server port number that is assigned to the DB2 subsystem.
The default is 446.
-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:
398 Application Programming Guide and Reference for Java
™