[OT] IDCAMS Error Counts?


All righty... there's a flat file that's used to load a VSAM KSDS.
Originally the file was de-duped with a SORT on the key field and the SUM
FIELDS=NONE control statement, eg:

SORT FIELDS=(5,9,CH,A)
SUM FIELDS=NONE

Now an additional field has been added to the sort which extends it to
something like:

SORT FIELDS=(5,9,CH,A,115,8,CH,D)

.... and the de-duping no longer occurs. When the result of the sort is
REPRO'd there are records with duplicate key fields present and IDCAMS
starts throwing sequence errors.

At the moment there are 86 dupe-key recs in a file of about 87K recs; the
quick fix is to up the IDCAMS tolerance for errors by specifying:

REPRO INFILE(INPUT1) OUTFILE(OUTPUT1) ERRORLIMIT(500)

.... and this should keep things happy until the limit is reached.

The question becomes... where would I find out how many errors IDCAMS has
encountered in a given build of the file? I can send the SYSPRINT to a
file and run a SORT to COUNT the IDC3314I messages... but I'd rather add
another step to the job as a last resort; it would be more elegant to find
a parameter to query.

DD

.

Relevant Pages

  • Re: [OT] IDCAMS Error Counts?
    ... > Originally the file was de-duped with a SORT on the key field and the SUM ... and the de-duping no longer occurs. ... > REPRO'd there are records with duplicate key fields present and IDCAMS ...
    (comp.lang.cobol)
  • Re: How do I alphabetize a column but also have the corresponding cells move with the sort?
    ... rows without repeating the name in the same row in column A would cause them ... to sort incorrectly. ... If you want to have multiple rows for a definition, ... you need to have a matching value in the key field. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How hash tables work
    ... Basically i need to sort my records by more than ... as a string or create an integer hash from fields. ... In my case it is possible to have duplicate hashes. ... >>So instead of doing a binary search on the first key field in the ...
    (alt.comp.lang.borland-delphi)
  • Re: SELECT . . . ORDER BY - SQL 2000 vs. JET 4
    ... mention locale. ... with this type of sort. ... I ended up doing a bubble-type sort on the key, and single inquiries ... use the ORDER BY statement, but, in the case of a key field, it may not be ...
    (microsoft.public.sqlserver.programming)
  • Re: How hash tables work
    ... Basically i need to sort my records by more than ... >one key field eg. ... code I hacked together to maintain multiple AVL tree indexes into ...
    (alt.comp.lang.borland-delphi)