NetBase SQL Shadowing Handbook

NetBase SQL Installation
____________________________________________________________
ver A0195 QUEST Software, Inc. 2-15
Excluding Tables
The previous examples have assumed complete shadowing of DBEs. Thanks to the INCLUDE
and EXCLUDE options on the SQLOUT commands, you may limit the shadowing of tables or set
up vertical partitioning. If you specify INCLUDE on an SQLOUT command, the corresponding
TABLE records for that DBE reflect the only tables to be included in shadowing for that DBE.
Conversely, if you use the EXCLUDE option on the SQLOUT command, the corresponding
TABLE records reflect the tables to be omitted from shadowing.
TABLE
This command is used to enter TABLE records to be included or excluded from SQL shadowing.
SYNTAX:
D> TABLE dbename,node,tablename[,RESET]
The tablename entry designates the table being included/excluded (depending on the associated
SQLOUT command) from shadowing.
The RESET option removes the table entry from the directory.