![]() |
Cloudsync Commands Reference
|
|
COPY PUBLICATIONCreates a file from which to create a target database. This statement can only be executed on a source database. Syntax
COPY PUBLICATION PublicationName PublicationName and ParameterName are SQL-J-style identifiers. (See the Cloudscape Reference Manual for more information on SQL-J identifiers.) PublicationName is schema-qualifiable and ParameterName is not schema-qualifiable. You must have operating system write permission on the destination file. FileName is a string delimited by single quotes ('). FileName can use either a relative path (to the database's JVM's current working directory) or an absolute path, and uses operating system, not URL, syntax. If the specified file already exists, it is overwritten. When copying a publication to a file, you can specify values for the parameters. Parameters not stated in the COPY PUBLICATION statement assume their default values. Parameter values are plugged into the WHERE clauses (defined at CREATE PUBLICATION time) to pick out the desired rows. When a CREATE PUBLICATION statement is prepared, COPY PUBLICATION's ParameterName values and FileName can be "?" parameters that will be specified at run-time. COPY PUBLICATION always occurs at isolation level 3 (SERIALIZABLE), even if the current transaction is at another isolation level. To see the parameter values in an existing target:
For example, the following query at the target returns the target's parameter information:
SELECT * FROM SYS.SYSCOLUMNS See CREATE PUBLICATION for details about publication contents. Example
-- issued at source
-- in a prepared statement |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |