IBM DB2 User Manual

Example: Putting DB2JccConfiguration.properties in a JAR file: Suppose that your
configuration properties are in a file that is in EBCDIC code page 1047. To put the
properties file into a JAR file, follow these steps:
1. Rename DB2JccConfiguration.properties to another name, such as
EBCDICVersion.properties.
2. Run the iconv shell utility on the z/OS UNIX System Services command line to
convert the file contents to Unicode. For example, to convert
EBCDICVersion.properties to a Unicode file named
DB2JccConfiguration.properties, issue this command:
iconv -f ibm-1047 -t utf-8 EBCDICVersion.properties \
> DB2JccConfiguration.properties
3. Execute the jar command to add the Unicode file to the JAR file. In the JAR
file, the configuration properties file must be named
DB2JccConfiguration.properties. For example:
jar -cvf jdbcProperties.jar DB2JccConfiguration.properties
Related tasks
“Installing the z/OS Application Connectivity to DB2 for z/OS feature” on
page 435
Chapter 9, “Migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the
IBM Data Server Driver for JDBC and SQLJ,” on page 439
Chapter 16, “Tracing IBM Data Server Driver for JDBC and SQLJ C/C++ native
driver code,” on page 491
“Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version”
on page 434
Related reference
“db2jcctrace - Format IBM Data Server Driver for JDBC and SQLJ trace data for
C/C++ native driver code” on page 491
“ IBM Data Server Driver for JDBC and SQLJ configuration properties” on page
239
Enabling the DB2-supplied stored procedures and defining the
tables used by the IBM Data Server Driver for JDBC and SQLJ
Before you can use certain functions of the IBM Data Server Driver for JDBC and
SQLJ on a DB2 for z/OS subsystem, you need to install a set of stored procedures
and create a set of tables.
WLM must be installed on the z/OS system.
The stored procedures that you need to installed are:
v SQLCOLPRIVILEGES
v SQLCOLUMNS
v SQLFOREIGNKEYS
v SQLFUNCTIONCOLUMNS
v SQLFUNCTIONS
v SQLGETTYPEINFO
v SQLPRIMARYKEYS
v SQLPROCEDURECOLS
v SQLPROCEDURES
v SQLSPECIALCOLUMNS
v SQLSTATISTICS
v SQLTABLEPRIVILEGES
v SQLTABLES
418 Application Programming Guide and Reference for Java
™
|
|

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability