Discover and propose complete Db2 duplicate precheck keys
ProprietaryDiscover COUNT prechecks and their matching INSERT operations throughout the input source set. Bind reusable table and success-message policies. Locate approved schema contents by fingerprint and derive paths, source identities, COPY snapshots, count fields and statement locations. Reuse complete key, SQL grammar, host binding, diagnostic, result handling and terminal-exit proofs. Append missing primary-key equalities from unchanged INSERT values and preserve existing database enforcement and error behavior. Apply candidates in source order and locate them by syntax identity after earlier insertions. No caller or schema paths, program IDs, statement lines, caller hashes or local host names are required. Schema deployment approval remains explicit. The precheck does not prevent concurrent duplicate attempts or replace database uniqueness enforcement. 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. The schema hash identifies the independently approved complete enforced DDL. The reusable table policy approves the complete primary key comparison and existing result handling for every matching precheck, INSERT and literal success report. Conflicting policies prevent changes. Omit this option to inventory COUNT prechecks 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.