Neoview SQL Reference Manual (R2.5)

REPLICATE Command
• “Syntax Description of REPLICATE ”
• “Considerations for REPLICATE ”
• “Examples of REPLICATE”
The REPLICATE command is a syntax-based utility that can be executed from any interface
where an SQL command can be executed.
The REPLICATE command allows an Neoview installation to replicate a table or an entire schema
from one Neoview system to another. The REPLICATE command behaves like any other SQL
command in that it can be issued anywhere an SQL command can be issued. The REPLICATE
command provides user-settable options, such as the priority of replication and progress
monitoring via query ID.
IMPORTANT: The REPLICATE command executes with cursor-like behavior and returns status
information for each task that it performs. If you plan to use the REPLICATE command in a
JDBC or ODBC application, you must use fetch calls with the REPLICATE command.
The REPLICATE command can be used to replicate:
• DDL for all objects in a schema. See “Replicating an Entire Schema” (page 226).
• Data for single table and dependent indexes. See “Single-Table Replication” (page 227).
• Data for multiple tables in a list. See “Replicating Multiple Tables” (page 227).
• Data for multiple tables in a schema. See “Replicating Multiple Tables” (page 227).
• Statistics for all tables in a schema. See “Replicating Statistics” (page 228).
REPLICATE object-specification, target-system-specification
[, replicate-options]
[, target-option]
[, control-options]
[, schema-repl-options]
object-specification is:
[SOURCE TABLE src
| SOURCE TABLES IN (src, ... srcN)
| SOURCE SCHEMA schema [, source-filter]
target-system-specification is:
TARGET SYSTEM node
replicate-options are:
PRIORITY number | PRIORITY_DELTA number
CONCURRENCY [MAX | DEFAULT | number]
COMPRESS [OFF | ON]
target-option is:
PURGEDATA TARGET
NO TRANSFORM TARGET
control-options are:
GET STATUS FOR QID 'query_id'
ABORT QID 'query_id'
RECOVER
schema-repl-options are:
COPY DDL
COPY STATISTICS
source-filter is:
SOURCE [NOT] LIKE 'pattern'
224 SQL Utilities