Appendix C: Sample Load File

A load file sample for creating, replacing, or materializing tables.

###############################################################
##Comments begin with the # sign
##Each line will define the options for tables that are to be included
###############################################################
## The CUSTOMER table will be created on start of replication,  
## it will replace an existing table of the same name,
## it will be materialized and its creation will be deferred
## until there is activity in it if it is empty
###############################################################
CUSTOMER,create,replace,materialize, defer
##
###############################################################
## The DISTRICT table will not be created on start of replication,  
## it will not replace an existing table of the same name,
## it will not be materialized
## and it will not have deferred creation if it is empty 
## on replication startup
###############################################################
DISTRICT
##
HISTORY,create,replace
ITEM, create, replace
NEW_ORDER, create, replace
OORDER, create, replace
STOCK, create, replace
WAREHOUSE, create, replace