Contact us

← What's new

Import DB2 SQL straight from COBOL, and drive queries from copybooks

A DB2 asset can now be created from a COBOL program without a live connection. [[feature:integration-mainframe-connectors|Mainframe connectors]] reads the embedded SQL, returns one statement per distinct cursor query, skips a FETCH whose cursor was never declared, drops optimiser hints, and picks up host variables declared in working storage — so a program can be turned into an asset from source alone, offline.

DB2 assets also take copybooks for the input and the output of a query, instead of only the shape the connector infers. Where a query uses input host variables and the output copybook wraps its rows in a repeating group, that group is now unwrapped rather than refused; a copybook shared by both sides is still read strictly.

Read more