mpe_targetloader.test.sas File Reference

Testing mpe_targetloader macro - REPLACE loadtype. More...

Go to the source code of this file.

Detailed Description

Covers the REPLACE branch of mpe_targetloader.sas:

LOADTARGET=NO (diff screen preparation) - all staged records classed as
new, all existing records classed as deleted, target table unchanged
LOADTARGET=YES (actual load) - target table fully replaced by the
staging table, delete flag column dropped, processed column stamped,
per-record delete flags ignored (everything is loaded)

A dedicated DCTEST.DC_REPLACE table is registered in MPE_TABLES (and the registration removed again in cleanup). The DCTEST library is BASE engine, so the CAS-specific branch (deleteRows truncation / varchar casting) is not exercised here.

SAS Macros

• mp_assert.sas
• mp_assertdsobs.sas
• mp_assertscope.sas
• mpe_targetloader.sas

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file mpe_targetloader.test.sas.