Mapping data

Mapping tells FM/Db2 how you want columns transferred from an old table to a new table. You can set up mapping so that, in the extreme case, a column is copied to a column of a different name, with a different length, and with a different, but compatible, data type. Most mappings are more straightforward.

Other types of mapping supported by FM/Db2 include:
  • Mapping the columns of one table to another.

    You can use this type of mapping with the FM/Db2 Copy utility.

  • Mapping the columns of a table to the fields in a file.

    You can use this type of mapping with the FM/Db2 Export utility and the Db2® UNLOAD utility.

  • Mapping the fields in a file to the columns of a Db2® table.

    You can use this type of mapping with the FM/Db2 Import utility and the Db2® LOAD utility.