Skip to main content

IBM AS/400 (Beta)

IBM AS/400 is a relational database management system that runs on IBM i (formerly AS/400) systems. It is tightly integrated with the IBM i operating system, providing high performance, security, and reliability for enterprise workloads.

Prerequisites​

The following prerequisites must be met for a user to create and test a successful connection:

  • The IBM AS/400 server must be accessible from the iceDQ server.
  • Valid credentials to access the database.
  • A supported JDBC driver.
IMPORTANT

This connector is currently in Beta version and should not be used in production environments.

Authentication Mechanism​

The following authentication mechanism is supported:

  • Username & Password

Connection Properties​

Use the following properties to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *      Name that uniquely identifies the connection.Prod_sales_conn
Driver *Driver used to establish the connection. By default, one driver is available.AS400 Native JDBC
Custom JDBC URLStandardized string used to define the connection details. Use this format supported by the driver: jdbc:as400://[servername]/[database]jdbc:as400://as400.acme.com/PRODLIB
Server Name *The hostname or IP address of the IBM AS/400 system.as400.acme.com or 179.148.30.52
Database *Name of the target database (library).PRODLIB
Type *The connection type – either System Connection or User Connection. Refer Connections for more details.System or User
Username *Database login username with necessary privileges.john_doe
Password *Password associated with the specified username.Admin@123

Custom Properties​

Custom properties are optional connection parameters in the AS400 Native JDBC driver, allowing customization of settings like SSL, libraries, naming conventions, and timeouts. A list of supported properties is available here. The availability and behavior of these properties may vary depending on the AS400 JDBC driver version.

Unsupported Datatypes​

The following datatypes are not supported (varies by driver and implementation):

  • DATALINK
  • DISTINCT
  • STRUCT
  • ARRAY
  • ROWID
  • XML
Last updated on