VMS Help  —  RMU72  Load  Database  Command Qualifiers, Corresponding
    Corresponding

    Loads fields into a table from the .unl file by matching the
    field names in the .rrd file to the column names in the table.
    The Corresponding qualifier makes it more convenient to unload,
    restructure, and reload a table.

    For example, if the columns in the table appear in the order:
    EMPLOYEE_ID, LAST_NAME, FIRST_NAME, but the data in your .unl
    file appears in the order: EMPLOYEE_ID, FIRST_NAME, LAST_NAME,
    and your .rrd file lists the fields in the order: EMPLOYEE_ID,
    FIRST_NAME, LAST_NAME, you can use the Corresponding qualifier
    to load the data in your .unl file correctly. (You could also use
    the Fields qualifier to accomplish the same task, but this can
    get tedious if there are numerous fields.)

    The .unl file must contain data for each field in the database
    into which it is being loaded; if it does not, you should use the
    Fields qualifier.

    If the Corresponding qualifier is omitted, the RMU Load command
    loads the data into database fields by the ordinal position in
    which they appear in the .unl, not by the column name described
    in the .rrd file.

    The Corresponding qualifier cannot be used with either the Fields
    or Audit qualifiers.
Close Help