1.1.1

secondary buckets of a partitioned table if the table was created with REDUNDANCY ClauseExample with
REDUNDANCY Clause. To include the redundant buckets, specify the query hint --sqlfire-properties
withSecondaries = true as shown in the example.
Note: Because optimizer properties are expressed as comments, they must appear at the end of a line. If
you want to continue the SQL statement after including a property definition, enter a newline character
(\n) before continuing the statement. This rule applies to the terminating semicolon, if the optimizer hint
appears at the end of the SQL statement.
Example
-- find out current process distributed member id
VALUES dsid();
-- get members where a partitioned table is defined.
SELECT DISTICT dsid() FROM emp.employee;
-- number of rows present on each member of a partitioned
table.
SELECT count(emp_id), dsid() FROM course, sys.members GROUP
BY dsid();
-- number of rows including secondary copies present on each
member of a partitioned table.
SELECT count(emp_id), dsid() FROM course, sys.members m
--sqlfire-properties withSecondaries = true \n
GROUP BY dsid();
GROUPS Function
Returns the current distributed member's server groups as a comma-separated list in the sorted order.
GROUPSINTERSECT Function
Return a boolean result. This function is a variant of the GROUPSINTERSECTION function.
See GROUPSINTERSECTION Function for more information. You can use GROUPSINTERSECT as part of
a SelectExpression
GROUPSINTERSECTION Function
Get the intersection of two comma-separated, sorted server groups lists. A zero-length string represents empty
server groups. NULL represents the default server group, which includes all data stores.
GROUPSUNION Function
Return the union of two comma-separated, sorted lists of server groups. A zero-length string represents empty
server groups. NULL represents the default server group, which includes all data stores.
Built-in System Procedures
Certain SQLFire built-in system procedures manage features of the distributed system, such as database caching.
These built-in system procedures are not compatible with other relational databases. SQLFire also includes many
standard built-in procedures that are provided with Apache Derby.
Note: If you enable SQL authorization, you must use the GRANT command to grant normal users
permission to use these procedures.
Standard Built-in Procedures
SQLFire includes many data and query management procedures from Apache Derby.
SYSCS_UTIL.EMPTY_STATEMENT_CACHE
Remove as many compiled statements (plans) as possible from the database-wide statement cache.
595
SQL Language Reference