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

Properties

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.

For More Information

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