Discover and propose Db2 INSERT response guards
ProprietaryDiscover INSERT statements and literal success reports under reusable table contracts. Derive caller and schema paths, program identities, statement locations and COPY snapshots. Require complete enforced schema, every inserted column, ordinary hosts, matching diagnostics and absent lexical handlers. Reuse existing terminal duplicate and SQL error paths. Propose guards for an immediate unchecked success report and preserve every original statement. Relocate candidates by syntax identity after earlier insertions and record unresolved proofs. No source paths, program IDs, statement lines or caller hashes are required. Schema enforcement and failure behavior remain explicit approvals. Application team review remains required.
io.Optional
Strict JSON with version 1 and a rules array. Each rule supplies id, table, successMessage, schemaSha256, diagnosticMode, errorExit, duplicateExit and contractSource. Approve every matching INSERT and exact single-literal success report in the input set. Only SQLCODE zero permits the success report. Approve the existing terminal duplicate exit for SQLCODE -803 and error exit for every other nonzero result. The schema fingerprint independently approves complete enforced DDL. Diagnostic mode is STDSQL(YES) or STDSQL(NO). Preserve messages, cleanup and transaction behavior. Omit policies for inventory without edits.
mod run .Install it once from Recipe actions, then run it on every repository under the current directory. New to the Moderne CLI? Set it up.