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
Contact Cleo Support for Studio questions, and review the IBM Toolbox for Java properties for jdbc connections.
Comments
0 comments
Please sign in to leave a comment.