![]() |
Cloudsync Commands Reference
|
|
REFRESHPerforms a refresh operation. This statement can be executed only on a target database. SyntaxREFRESH [ PROPERTIES clause ] PROPERTIES clause
propertyName = CharacterExpression
The connection waits until the refresh has completed. The PROPERTIES clause allows a target application to provide parameters to the source for application-defined refresh authentication. The property values must be String literals; you cannot use dynamic parameters (?). Since those Strings are SQL-J identifiers, delimit those strings if they contain any lowercase characters. For more information, see Chapter 5, "Refresh Authentication". NEW: The PROPERTIES clause of the REFRESH command is new in Version 3.6. You cannot run REFRESH if there is already uncommitted work in the transaction. An application is temporarily blocked if it runs the REFRESH command and there is open work in other transactions. REFRESH implicitly commits when it completes successfully. You cannot roll back a successful refresh operation. REFRESH fails with an error in any of the following cases:
If the target has been cloned, or the source has been copied or restored from a backup, the following cases also cause REFRESH to fail with an error:
NOTE: If you upgrade the locale for the source database, the target database picks up the new locale until the first subsequent REFRESH. For more information about localization, see the localization appendix in the Cloudscape Developer's Guide. Examples |
|
![]() 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. |