NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-73
Considerations—DUP
indexes being duplicated as part of duplicating a table. (For an example, see the
discussion of Target Specification later in this entry.)
•
If constraints or statistics exist for a table that is duplicated, DUP applies the
constraints and statistics to the new table and records them in the appropriate
catalog tables of the catalog for the new table.
Rules for views
•
target-fileset or the MAP NAME option you specify determines how
DUP translates table and view names (in the FROM clause of the SELECT
command in the view definition) to the new view definition.
•
You can explicitly specify the name of a protection or shorthand view in
source-fileset-list if you also specify VIEWS EXPLICIT.
•
The new copy of a protection view that you duplicate explicitly must reside on
the same volume and be defined in the same catalog as the new table on which it
is defined.
•
DUP does not duplicate shorthand views built on top of protection views unless
you specify VIEWS EXPLICIT.
•
Because a shorthand view definition might reference tables and views that have
not yet been duplicated, such a definition is invalid when DUP initially creates
it. After duplicating all objects involved in the DUP operation, DUP attempts to
validate the shorthand view definition. If the DUP operation does not complete
for any reason, or if you specify an invalid mapping scheme, a view definition
might be left in an invalid state.
Rules for SQL program files
•
DUP does not register duplicated programs in an SQL catalog. Unless a
duplicated SQL program was compiled with the NO REGISTER option, you
must execute SQLCOMP to register the program in an SQL catalog before you
can execute the program.
If the original program was compiled with the CHECK INOPERABLE plans
option and referenced tables and views have the SIMILARITY CHECK option
enabled, you can use the REGISTER ONLY option of the SQLCOMP command
to register the program through SQLCOMP without recompiling it. If not, you
must SQL-compile the program again. For more information, see the NonStop
SQL/MP programming manual for your host language.
•
DUP cannot duplicate an SQL program in an OSS file. An error occurs if you
specify an OSS program in source-fileset-list.
Rules for collations
•
When you specify both collations and other SQL objects in source-
fileset-list and any of the other SQL objects references one or more of
the collations, DUP copies the collations before the SQL objects. If collations
are the only objects in source-fileset-list, DUP copies the collations
and then updates the CPRULES and CPRLSRCE catalog tables.