Fix a failed run from the job page, with AI for the hard cases

When a batch run from CoreIQ (VSAM or IMS) rejects rows, you can now fix its mapping straight from the job page. Tick the causes you want fixed and click Fix in DataIQ. DataIQ opens the mapping editor with the fixes already filled in: allow nulls in a column the source leaves empty, widen a column that's too short for its source field, or move the key off a field that was empty. You check them, skip any you don't want, and save them as one new mapping version that the next run uses. Causes spread over several tables are fixed one table at a time.

Besides the fixes a run asks for, the editor also points out what a later run could hit. When the copybook declares a field longer than its column, for example a 59-character field loading into a VARCHAR2(10), the field's source type turns red and a widen to 59 link appears beside the column. These aren't applied with the fixes, because the run's own data didn't need them: no value in that run was too long. Each one is a click away if you'd rather size the column for anything the source can send.

The editor can now also widen a column and change its type. A type mismatch, such as a 50-character name loaded into a NUMBER, is often fixed by giving the column the right type. An empty column can take any type; a column with values can be changed to text long enough to hold every value. Before saving, the editor lists the exact table changes and says that restoring an older version won't undo them.

For causes no rule can fix, DataIQ can ask AI for a suggested edit when an AI provider is set up. The job page marks those causes with ✦ AI can suggest. The AI is given facts only (the causes, the mapping, the copybook's fields, the table's columns and counts), never your records. Its suggestion is checked by the same rules as a save, marked as AI in the editor, and never saved without you.

A refused row is now checked against every column of the table, so one run reports all of a row's problems and not only the first one the database stopped at.