CSV File Information (PrefixINFO) Data Structure

The variables described in this section are used by the CSV APIs and contain information about the CSV file.

Note: These CSV routines use the same wild card values in the external file names and the data formatting as the lashow CSV extraction utility.
Field Description

<Prefix>INFO-NBR-FIELDS

The number of fields defined in the file

<Prefix>INFO-RECORD-COUNT

The number of records in the file.

<Prefix>INFO-HANDLE

The file handle. Up to 10 characters.

<Prefix>INFO-FILE-OPEN

Indicates the status of the file.

Y = the file is open.

N = the file is closed.

The default is N.

<Prefix>INFO-FOUND

Indicates whether the file exists.

<Prefix>INFO-FILENAME

The file name. The name can be up to 60 characters.

<Prefix>INFO-INFO-SET

One character.

<Prefix>INFO-FILE-OPTS

A field made up of the following subfields:

  • <Prefix>INFO-HAS-HEADER

    The default is Y.

  • <Prefix>INFO-XLT-HEADER

    The default is Y.

  • <Prefix>INFO-DATE-FMT

    The default is CCYYMMDD.

  • <Prefix>INFO-FLD-SEP

    The default is a comma.

  • <Prefix>INFO-DATE-SEP

    The default is a forward slash.

  • <Prefix>INFO-TIME-SEP

    The default is a colon.

  • <Prefix>INFO-DEC-SEP

    The default is a period.

  • <Prefix>INFO-THOU-SEP

    The default is no separator.

  • <Prefix>INFO-QUOTE-CHAR Lawson 4GL)

    The default is a double quote.

  • <Prefix>INFO-FILE-TERM

    The file termination character.

  • <Prefix>INFO-LINE-TERM

    The line termination character.

  • <Prefix>INFO-MISC-OPTS

<Prefix>INFO-OLD-FLD-NAME

The 30-character field name 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.

<Prefix>INFO-NEW-FLD-NAME

The new 30-character field 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 10-character field type is entered as the text name for an element type.