bitemporal_closeouts.sas File Reference

Closes out records. More...

Go to the source code of this file.

Detailed Description

Closes out records from a temporal table by reference to a single temporal range + business key. Only live records are closed out, so the entire key should be provided in the input table EXCEPT the TECH_FROM. All records matching the key (as per the input table) are closed out on TECH_TO.

Returns an updated base table and &mpelib..mpe_dataloads table

Potential improvements - write the update statements as a text file and retain for future reference!

Parameters

[in]	now=	(DEFINE) Allows consistent tracking of tech dates. Should be a date literal, not a numeric constant, for DB compatibility.
[in]	load_type=	Set to UPDATE if non-temporal, else assumed to be TXTEMPORAL. Note that BITEMPORAL is treated the same as TXTEMPORAL given that BUS_FROM should be supplied in the PK.
[in]	tech_from=	(tx_from_dttm) Technical FROM datetime variable. Required on BASE table only.

Global Variables

• dc_dttmtfmt

SAS Macros

• mp_abort.sas
• mf_existvar.sas
• mf_getattrn.sas
• mf_getuser.sas
• mf_getvartype.sas
• mp_lockanytable.sas
• dc_assignlib.sas

Version

9.2

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 bitemporal_closeouts.sas.