(525) Dynamic table selection

QMirror/DB supports dynamic table selection, which downloads and replicates tables after around 10 minutes they are created on the AS400.

(Note: The empty physical files on the AS400 will not be processed by the trial version.)

E.g. A daily transaction file named TRNyymmdd is created in library INVLIB on AS400 every morning. To let QMirror/DB download and replicate it, insert a record into system table ZAMTBS manually.

INSERT INTO QMIRROR.ZAMTBS (TBLIB,TBGEN,ATOJRN,LFLIB) VALUES(‘INVLIB’,’TRN*’,’Y’,’INVLIB’)

Refer to (A17) Dynamic selection master (ZAMTBS)

Previous (520) Create extra indexes in the target database
Next (530) Define extended fields in the target database