Create a Java Application - Accessing DB2 9.1 on System z

Sep 2, 2026

Upload by Paura

Create a Java application using RDz to access a DB2 9.1 database running on System z (z10). The guide focuses on setting up RDz connections and switching to the Java Perspective, creating a Java project, package, and class, and then implementing JDBC code to connect to the DB2 host, execute a SQL query against a DB2 table, and print the result set. It also includes driver loading, parameterized connection inputs, and error-handling with SQL state and messages.

LanguageEnglish

CategoryGeneral

FormatDOCX

Pages9

Reading Time3 min

AccessFree to download

Module Objectives

RDz Setup and Java Perspective

Create Java Project and Package

Create Java Class and Program Template

JDBC Code to Access DB2 9.1

Run Configuration

Module Objectives: Become proficient in the RDz Java Perspective Be able to extract data from a DB2 table using Java Creating a Java program to access DB2 9.1 on System z Create a Java Application This example creates a Java application that runs against DB2 9.1 on the host (z10). One must create the DB2 9.1 table before this project will run. Open RDz and ensure you have a z/OS connection (Remote System). To create a Java Project, you will need to open the Java Perspective. To switch to the Java Perspective: 1. Perspectives that have been opened in RDz are kept usually as expandable tabs in the upper right corner of your Remote System perspective. If you have not previously opened the Java perspective, click Window => Perspective => other. A dialog box displays. 2. Select Java and click OK. RDz automatically arranges the windows, views, and editors for Java development tasks. Package Explorer (only Packa displayed) is shown below. To create a Java project: 1. Click File => New => Project => Java Project 2. Click the Next button and name the new project –JDBCJava for this example. Accept the default values and click the Finish button (not shown). The result is shown below. To create a Java package within the project: 1. Right-click the project (JDBC Java in this case) in the Package Explorer window and select New => Package 3. Enter a name for the new package such as com.acctid (com.douglas in this case) and click the Finish button (not shown) The package is created as shown To create a Java class: 1. Right-click the project (JDBCJava) in the Package Explorer window and select New => Class. 3. Use the Browse button to select your package, for example com.douglas 4. Enter your class name; for example, DisplayNames 5. Click the box for public static void main and then click the Finish button. RDz creates a Java programming template as shown below. The Program--copy the following Java Program into the DisplayNames Java program The package statement should be in your Java editor—my specific package is package com.douglas; Enter the following import statements--between the package name and the class--to import the Java classes needed for this application import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; The class and main subroutine headers are already created in the Java Editor. Thus, do not copy and paste them. ---------------------------------------------------- public class DisplayNames { /** * @param args */ public static void main(String[] args) { Copy the following code into the main program stub—note some comments that show the DB2 9.1 table structure System.out.println("<<< Entering DisplayNames >>>"); if (args.length != 3) { System.out.println("required: location_name"); System.exit(0); } try { Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance(); String url = "jdbc:db2://stplex4a.svl.ibm.com:8028/" + args[0]; Connection connection = DriverManager.getConnection(url, args[1], args[2]); showPeople(connection); connection.close(); } catch (SQLException ex) { System.out.println("\n***SQLExecption caught***\n"); while (ex != null) { System.out.println("SQLState: " + ex.getSQLState()); System.out.println("MEssage: " + ex.getMessage()); System.out.println("Vendor: " + ex.getErrorCode()); ex = ex.getNextException(); } System.out.println("===================================="); } catch (java.lang.Exception langEx) { System.out.println("\n***java.lang.Execption caught***\n"); langEx.printStackTrace(); } } /** * showPeople method * * CREATE TABLE FRIENDZ ( * FNAME CHAR(10) NOT NULL, * LNAME CHAR(10) NOT NULL, * PHONE CHAR(10) NOT NULL, * EMAIL CHAR(30) NOT NULL * ) * AUDIT NONE * DATA CAPTURE NONE * CCSID EBCDIC; * **/ protected static void showPeople(Connection connection) throws SQLException { System.out.println("<<< showPeople method >>> "); Statement stmt = connection

FAQs

What prerequisites are required before running the Java application?

A z/OS connection must be available in RDz, and the DB2 9.1 table structure must be created before the project runs.

How does the example create the Java project in RDz?

In RDz, create a Java Project via File > New > Project > Java Project, name it (e.g., JDBCJava), accept defaults, and finish.

How does the program connect to DB2 9.1 and retrieve data?

It loads the DB2 JDBC driver, builds a JDBC URL using the first argument as location, uses userid and password from the remaining arguments, establishes a connection, executes a SELECT query, and prints the result set metadata and rows.

Sep 2, 2026

Upload by Paura