1.1

• EXTERNAL NAME
parameter-style
JAVA | DERBY_JDBC_RESULT_SET
The function will use a parameter-passing convention that conforms to the Java language and SQL Routines
specification. INOUT and OUT parameters will be passed as single entry arrays to facilitate returning values.
Result sets can be returned through additional parameters to the Java method of type java.sql.ResultSet[] that
are passed single entry arrays.
SQLFire does not support long column types (for example Long Varchar, BLOB, and so on). An error will occur
if you try to use one of these long column types.
The PARAMETER STYLE is DERBY_JDBC_RESULT_SET if and only if this is a SQLFire table function,
that is, a function which returns TableType and which is mapped to a method which returns a JDBC ResultSet.
Otherwise, the PARAMETER STYLE must be JAVA. See Using Table Functions to Import Data as a SQLFire
Tables on page 103.
CREATE GATEWAYRECEIVER
Creates a gateway receiver to replicate data from a remote SQLFire cluster.
Syntax
CREATE GATEWAYRECEIVER receiver-name
(
[ BINDADDRESS 'address' ]
[ STARTPORT integer-constant ]
[ ENDPORT integer-constant ]
[ SOCKETBUFFERSIZE integer-constant ]
[ MAXTIMEBETWEENPINGS integer_constant ]
) [ SERVER GROUPS ( server_group_name [, server_group_name ]*)]
receiver-name
A unique identifier for this receiver. You can use this identifier with the DROP
GATEWAYRECEIVER statement to remove the receiver configuration if necessary.
BINDADDRESS
The network address to use for connections from gateway senders in other sites. Specify the
address as a literal string value.
STARTPORT
The starting port number to use when specifying the range of possible port numbers this gateway
receiver will use to for connections from gateway senders in other sites. SQLFire chooses an
unused port number in the specified port number range to start the receiver. If no port numbers
in the range are available, an exception is thrown.
The STARTPORT value is inclusive while the ENDPORT value is exclusive. For example,
if you specify STARTPORT=50510 and ENDPOINT=50520, SQLFire chooses a port value
from 50510 to 50519.
If you do not specify STARTPORT, the default value is 5000.
ENDPORT
Defines the upper bound port number to use when specifying the range of possible port numbers
this gateway receiver will use to for connections from gateway senders in other sites. SQLFire
chooses an unused port number in the specified port number range to start the receiver. If no
port numbers in the range are available, an exception is thrown.
vFabric SQLFire User's Guide468
vFabric SQLFire Reference