Cloudsync Commands Reference
Page 5 of 8

CREATE WORK ALIAS

Declares two static Java methods as a work unit. This statement can only be executed on a source database.

Syntax

CREATE WORK ALIAS WorkAliasName
FOR SourceMethodName [, TargetMethodName ]

Work units are modeled on method aliases. Like method aliases, they are never qualified with a schema name.

If the target method is not found, an error is raised when the work unit is invoked, and if the source method is not found, an error is raised at refresh time, and the refresh halts.

If the source method and target method do not have the same number and type of parameters, CREATE WORK ALIAS fails at run time.

If you don't specify the TargetMethodName, it is assumed to be same as the SourceMethodName.

The name of a work unit cannot duplicate the name of a method alias or user-defined aggregate.

See the Cloudscape Reference Manual for information on the related CREATE METHOD ALIAS command.

Example

CREATE WORK ALIAS placeOrder
    FOR SourceWork.makeSaleAtSource,
        TargetWork.makeSaleAtTarget