IBM i

Overview

IBM i is a fully integrated platform combining hardware, OS, and a built-in relational database (Db2 for i). DBCode connects via the JT400 JDBC driver, giving you direct access to SQL tables, views, procedures, and more from Visual Studio Code.

Authentication

IBM i connections require:

  • Hostname or IP address
  • Port number (default is 446 for DRDA)
  • Username (IBM i user profile)
  • Password

SSL/TLS and SSH tunnel connections are also supported.

Connect to an IBM i Database

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon.
  3. Complete the New Connection Form: Choose IBM i as the type, and enter the required connection details (hostname, port, username, password).
  4. Connect: Click save to connect to your IBM i system.
  5. Start Exploring: Browse schemas (libraries), tables, views, procedures, functions, and sequences.

For detailed instructions on connecting, refer to the Connect article.

IBM i Features in DBCode

DBCode supports progressive schema loading for IBM i, which means large systems with thousands of tables load quickly by fetching schema contents on demand rather than all at once.

Supported object types:

  • Tables and views with column details, indexes, constraints, and foreign keys
  • Stored procedures and functions with parameter metadata
  • Sequences
  • DDL generation for procedures and functions (editable and reapplicable)

For more information about IBM i, check out IBM i.