Database Operations

DB2, IMS-DB, and DB400 endpoints let you execute SQL and browse database structures.

Query and browse

Run SQL with a configurable page size and use Prev and Next to page results. Browse schemas, expand schemas to list tables, and inspect table structures. DB400 also supports browsing library files. IMS-DB Browse lists schemas (PCBs) and segments.

Table APIs

In DB2 → Schemas or IMS-DB → Browse, select Populate APIs on a schema to generate REST definitions. Choose operations—Get by PK, List, Create, Update, Delete, and Count—then confirm the key (relational PK or IMS hierarchic key) and optionally publish immediately.

IMS-DB can attach a COBOL copybook so the body is the decoded segment instead of JDBC columns. An IMS-DB delete removes the matched segment and every child beneath it.

Manage saved definitions in the host’s DB2 tab or IMS-DB → Table APIs tab. Published operations appear in the Dynamic OpenAPI spec.