NetBase for MPE Reference Guide

Using NBDIR
4-61
TABLE
The TABLE command works in conjunction with an SQLOUT command. The SQLOUT command
indicates whether the associated TABLE commands specify tables to be included or excluded from
shadowing. See the NetBase SQL Shadowing Handbook for more information.
Syntax
D> TABLE dbename,node,tablename[,RESET]
Parameters
Parameter Description
dbename
The name of the Allbase database.
node
The name of the node to which this table should or should not be
shadowed.
tablename
The name of the table being included or excluded (depending on the
associated SQLOUT command) from shadowing.
RESET
If this option is specified, the table entry is removed from the directory.
Example
Assuming DBE1 includes five tables and we are shadowing it from SYSA to SYSB. To exclude
TABLE4 (shadowing the rest), you could enter:
On SYSA:
:NBDIR.PUB.NETBASE
D> SQLOUT DBE1.DATA.PROD,SYSB;HOME=1;EXCLUDE
D> TABLE DBE1.DATA.PROD,SYSB,TABLE4
On SYSB:
:NBDIR.PUB.NETBASE
D> SQLIN DBE1.DATA.PROD,SYSA