(585) Define mapping table in the PC database

(Note 1: An additional license is required to enable QMirror/DB mapping functions.)
(Note 2: QMirror/DB upload function does not support multiple split mapped tables.)

Normally, QMirror/DB replicates AS400 physical files to the target database with the same naming rules.

Target database name= AS400 library name
Target table name= AS400 physical file name
AS400 physical file member name
Target column name= AS400 field name

You can use QMirror/DB system tables, ZAMTBM and ZWHFLM, to define your own naming rules. Up to nine split mapping tables can be defined for one AS400 physical file member by unique non-zero number in ZAMTBM.MAPSEQ.

AS400 library name:ZAMTBM.TBLIB=> ZAMTBM.MAPLIB
AS400 PF name:ZAMTBM.TBOBJ ZAMTBM.TBMBR=> ZAMTBM.MAPOBJ
AS400 field name:ZWHFLD.WHFLDI=> ZWHFLD.MAPFLD

Refer to (A15) Mapped table master (ZAMTBM)
(A125) Mapped filed master (ZWHFLM)

Previous (580) Selected download
Next (590) Upload data from PC database to AS400 

Table of Contents
Scroll to Top