SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-75
Considerations—DUP
or indexes being duplicated as part of duplicating a table. For an example,
see the target-fileset specification Considerations item on page
D-76.

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
information, see the 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