1.0

NAME
'com.sqlfire.funcs.Revenue.calculateRevenueByMonth'
Data-aware procedures
A Data-Aware Procedure is created using the same CREATE PROCEDURE syntax as specified above. The
difference for a data-aware procedure is in the way that the procedure is invoked with CALL PROCEDURE and
the way the procedure is implemented. For more information see Using Data-Aware Stored Procedures on page
143, and for information on implementing your own data-aware procedures, see Using the Procedure Provider
API on page 149.
CREATE SCHEMA
Creates a schema with the given name which provides a mechanism to logically group objects.
Syntax
CREATE SCHEMA schema-name [ DEFAULT SERVER GROUPS ( server_group_name on
page 461 [ , server_group_name on page 461 ] * ) ]
Description
This creates a schema with the given name which provides a mechanism to logically group objects by providing
a namespace for objects. This can then be used by other CREATE statements as the namespace prefix. For
example, CREATE TABLE SCHEMA1.TABLE1 ( ... ) will create a table TABLE1 in the schema SCHEMA1.
The DEFAULT SERVER GROUPS for a schema specifies the server groups used by the CREATE TABLE
statement by default when no explicit server groups have been mentioned.
Note: Specifying the default server groups for a schema does not limit tables in that schema to be in those
server groups, it just specifies the default server groups for tables in that schema.
The CREATE SCHEMA statement is subject to access control when the sqlfire.sql-authorization property is set
to true for the system. Only the system user can create a schema with a name different from the current user
name, and only the system user can specify AUTHORIZATION user-name with a user-name other than the
current user name.
There is no single owner of the entire distributed system. Instead, ownership is defined by the distributed member
joining the system. The distributed member process must boot up using theuser attribute in the properties to
indicate owner of that process. A member that boots in this way can create a schema or grant access to a schema
across the distributed system.
Example
CREATE SCHEMA myschema DEFAULT SERVER GROUPS
(srvrgrp1,srvrgrp2);
–- create schema that uses the authorization id 'shared' as
schema-name
CREATE SCHEMA AUTHORIZATION shared
-- create schema flights and authorize anita to all the
objects that use the schema.
CREATE SCHEMA flights AUTHORIZATION anita
CREATE SYNONYM
Provide an alternate name for a table or view.
vFabric SQLFire User's Guide448
vFabric SQLFire Reference