800-OVRDESCCSV

Name

800-OVRDESCCSV-<FileName>

Description

This API overrides the Field Header Name, Type, or both for one field in the specified file.

Both name and type can be changed in the same call. Once a field name has been changed, any future call to this routine for that field must use the new name. The name of the Working Storage field in the files REC area remains unchanged.

Any overrides must be done before the first write or read call to the file is made.

Input Values

Field Description
<Prefix>INFO-OLD-FLD-NAME

The name of the field to be changed is moved to the OLD-FLD-NAME field. If this value is spaces, the corresponding value on the file's FLD-DESC field is not changed.

If the Old Field Name entered does not match any fields on the file, the change is ignored and a message is written to the job log. Changing the field name of an occurring field changes all occurrences of the Old Field Name, substituting the new name but retaining the 01, 02... suffixes.

<Prefix>INFO-NEW-FLD-NAME

The new name is moved to the NEW-FLD-NAME field. If this value is spaces, the corresponding value on the file's FLD-DESC field is not changed.

The new field name is also used in matching columns and fields from an input CSV file. The matching field names and type values are not case sensitive.

<Prefix>INFO-NEW-FLD-TYPE

The new field type is entered as the text name for an element type.

Valid entries for NEW-FLD-TYPE are time, telephone and numeric. Alpha fields cannot be changed to numeric. Changes from numeric to time or telephone are edited for size. If an invalid type is entered or the Old and New field types are not compatible, the type is not changed and a warning message will be written to the job log. No error is returned to the program.

Return Values

The name and/or type of the CSV file is changed.