Start Today

← Phased modernization

Create the SQL table from the CoreIQ layout, not from JDBC metadata

We generated a CREATE TABLE from JDBC and the packed fields came out wrong. What should the column types follow?

Follow the approved COBOL copybook on the CoreIQ layout. [[product:ol-dataiq|OL DataIQ]] can open Create Table from CoreIQ for VSAM, or Import Legacy Schema for IMS, preview the mapping, and save it. JDBC metadata is the wrong source for those record layouts. Load the data only after the mapping looks right.

Read more