1.1.1

CREATE Statements
Use Create statements to create functions, indexes, procedures, schemas, synonyms, tables, triggers, and views.
CREATE ALIAS
Creates an alias for a user-defined procedure result processor.
Syntax
CREATE ALIAS processor_alias FOR 'processor_class'
Description
Data-aware procedures can optionally use a custom result processor to merge the procedure results that are
produced on multiple SQLFire members. If you do not invoke a procedure using a custom result processor,
SQLFire uses the Default Result Processor.
See Using the Custom Result Processor API on page 167 for information about implementing a custom result
processor.
processor_alias
The processor_alias is a user-defined alias for the result processor implementation. Use this alias when you call
a data-aware procedure to use the processor for mergin results. See CALL on page 474.
processor_class
The Java class of the result processor implementation.
Example
CREATE ALIAS mergesort FOR 'MergeSortProcessor';
CREATE ASYNCEVENTLISTENER
Installs an AsyncEventListener implementation to SQLFire peers in a specified server group.
Syntax
CREATE ASYNCEVENTLISTENER listener-name
(
LISTENERCLASS 'class-name'
INITPARAMS 'init-params'
[ MANUALSTART boolean-constant ]
[ ENABLEBATCHCONFLATION boolean-constant ]
[ BATCHSIZE integer-constant ]
[ BATCHTIMEINTERVAL integer-constant ]
[ ENABLEPERSISTENCE boolean-constant ]
[ DISKSTORENAME store-name]
[ MAXQUEUEMEMORY integer-constant ]
[ ALERTTHRESHOLD integer-constant ]
)
SERVER GROUPS ( server_group_name [, server_group_name ]*)
LISTENERCLASS
The fully-qualified name of the class that implements the AsyncEventListener interface. For
example, "user.application.TestAsyncEventListener". If you are configuring the built-in
DBSynchronizer implementation, specify com.vmware.sqlfire.callbacks.DBSynchronizer.
vFabric SQLFire User's Guide476
vFabric SQLFire Reference