Data Sources and IBM I

This example shows properties that must be specified on the URL when connecting to a Data Source on an IBM I, and using multiple libraries.

IBM I Example URL

jdbc:as400://IBMSystemI;naming=system;;translate binary=true;metadata source=0;libraries=LIB_A, LIB_B, LIB_C, *LIBL

Where:

Variable	Description
naming=system	Required for using multiple libraries.
translate binary=true	Used to convert data using CCSID 65535.
metadata source=0	Controls retrieval of metadata from the database.
libraries=LIBA, LIBB, LIBC, *LIBL	Specifies library list to use when fetching data. Comma or space-separated list Table names must be unique within the library list Specifying a default schema will override the library list.

Please contact Cleo Support or review the IBM Toolbox for Java properties for JDBC connections.