![]() |
Deploying Synchronized Systems
|
|
Locally Configuring Target Database PropertiesYou can directly set database-wide properties for target databases. Locally setting target database properties enables users to configure individual targets differently. For example, an application could configure each target to support a different set of users. Setting properties from the target database is optional; you can continue to publish properties as well. For a full discussion of properties, see the Tuning Cloudscape Guide. Setting PropertiesFull-access users can set target database properties locally. Setting database-wide properties from the target is handled in the same way as doing so from the source:
NOTE: The setDatabaseProperty method is in the COM.cloudscape.database.PropertyInfo class, for which Cloudscape has provided the alias PropertyInfo. The following example demonstrates using ij to: ij> CONNECT 'sourceDB'; The next example demonstrates a call that grants full-access user authorization to `Joe' on a target database:
CALL PropertyInfo.setDatabaseProperty( Checking Property ValuesTo check the current value of a property at a target database, use the getDatabaseProperty method, just as you would at a source or standard database. Connect to the database, then create a SQL-J statement containing the getDatabaseProperty method, passing in the name of the property whose value you want to check. To check the current values of all database-wide properties, use the getProperties() method. For example, the following statement retrieves a list of users with full database access:
VALUES PropertyInfo.getDatabaseProperty( SQLCol1 For more information about PropertyInfo, see the Tuning Cloudscape Guide and the API for COM.cloudscape.database.PropertyInfo. |
|
![]() 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. |