![]() |
Cloudsync Commands Reference
|
|
ALTER PUBLICATIONChanges an existing publication. This statement can only be executed on a source database. The effects of ALTER PUBLICATION are replayed at a subscribing target at its next refresh. Syntax
ALTER PUBLICATION PublicationName ParameterSpecParameterName DataType [ DEFAULT NULL ] The ADD and DROP statements can appear in any order. DROPs apply before ADDs, so you can DROP and ADD the same dictionary object in either order. The limitations on the WHERE restriction are the same as for the CREATE PUBLICATION statement. See CREATE PUBLICATION for more information. During the time a transaction containing ALTER PUBLICATION is uncommitted, no other transaction may: ALTER PUBLICATION cannot make a publication inconsistent or incomplete. To ensure this:
Like with any published object, before you can drop a published jar file, you must first drop all publications in which it appears. You cannot drop the file using COM.cloudscape.tools.dbclasses.removeJar. Instead, use COM.cloudscape.tools.dbclasses.replaceJar to replace the source jar file, and subsequent refreshes will update the target jar file. A refresh that changes a target's cloudscape.database.classpath produces a JDBC warning. See CREATE PUBLICATION for information on target properties you can include in a publication. Example
-- issued at source When you alter a publication to add a table or index, its properties are automatically set to match those of the tables at the source upon creation. |
|
![]() 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. |