Start Today

← What's new

Edit a saved mapping, with versions

A saved CoreIQ mapping, for a VSAM dataset or an IMS segment, can now be edited. Open Show mappings on a connection and edit a table's mapping: choose which source fields load and into which column, add a column, move the primary key, and allow or refuse nulls. On PostgreSQL and Oracle the editor changes the table to match; other databases point you to the Query Console.

The rows already in the table are checked before a new key or a NOT NULL is offered, so you learn up front, with counts, that some rows can't take it, not as a database error halfway through.

Every save is a new version, and none is overwritten. History lists the versions with who saved them and when, and restores any of them as the next version. Each batch run records which version of each mapping it used, so its failure causes describe the mapping as it was when it ran.

Read more