Access DB2 for i from LibreOffice Calc

How To

Summary

This document describes how to access DB2 for i from LibreOffice Calc using JDBC

Environment

IBM i

Java / JDBC

Steps

Follow these steps to connect LibreOffice to DB2 for i using the IBM Toolbox for Java JDBC driver:

1. Install Java

LibreOffice requires a Java Runtime Environment (JRE) to use JDBC:

Make sure Java is installed on your system.
In LibreOffice, go to Tools > Options > LibreOffice > Advanced and ensure a JRE is selected.

2. Download the JDBC Driver

To access DB2 for i, download the IBM Toolbox for Java jar file ("jt400-##.#.#.jar") from https://github.com/IBM/JTOpen. The .jar file contains the JDBC driver.

3. Add the JDBC Driver to LibreOffice

Go to Tools > Options > LibreOffice > Advanced.
Click Class Path > Add Archive.
Select the .jar file of your JDBC driver.
Restart LibreOffice after adding the driver.

4. Create a New Database Connection

Open LibreOffice "Base Database".
Choose Connect to an existing database > Select JDBC.
Enter the JDBC URL:
- DB2 for i: jdbc:as400://<systemName>/<defaultSchema>
Enter the JDBC driver class:
- com.ibm.as400.access.AS400JDBCDriver
- For example:
Click Next, then enter your username and password.

5. Test and Save

Click Test Connection to verify.
If successful, proceed and save the database file.

Related Information

Registering the JDBC driver

JTOpen JDBC

Importing Data into OpenOffice Calc With the IBM Toolbox for Java JDBC Driver

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CbKAAU","label":"Data Access-\u003EIBM i Toolbox for Java"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"6.1.0;7.1.0;7.2.0;7.3.0;7.4.0;7.5.0;7.6.0"}]

Tips