(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