To access your data in IBM Db2 for i, create a connection asset for it.
Db2 for i is the relational database manager that is fully integrated on your system. Because it is integrated on the system, Db2 for i is easy to use and manage.
Run the following commands from the Db2 client that is configured to access the Db2 for i server. You need to run the bind command only once per remote database per Db2 client version.
db2 connect to DBALIAS user USERID using PASSWORD
db2 bind path@ddcs400.lst blocking all sqlerror continue messages ddcs400.msg grant public
db2 connect reset
This connection has the option to use the JT400 toolkit. JT400 is a free toolkit that provides JDBC/ODBC drivers for accessing IBM i (formerly known as AS/400) systems. It provides a set of Java classes that can be used to access various resources
and services on an IBM i system, such as databases, data queues, program calls, and more.
Create a connection to Db2 for i
Copy link to section
To create the connection asset, you need these connection details:
Location: The unique name of the Db2 location you want to access
Username and password
SSL certificate (if required by the database server)
For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.
Choose the method for creating a connection based on where you are in the platform
For SPSS Modeler, you can use this connection only to import data. You cannot export data to this connection or to a Db2 for i connection connected data asset.
Running SQL statements
Copy link to section
To ensure that your SQL statements run correctly, refer to the Db2 for i SQL reference for the correct syntax.