Remote Analytic Executable Addressability

A remote AE address is specified as a set of up to four values in the form:

Remote Name, [Dataslice ID], [Session ID], [Transaction ID]}

Table 1. Remote AE address variables
Value	Description
Remote Name	Required. A string name.
Dataslice ID	Optional. The ID of a dataslice.
Session ID	Optional. The ID of the current Netezza system session that has an nzsql connection.
Transaction ID	Optional. A transaction ID.

On the Netezza system side (where the SQL function is called), the AE is registered with settings that specify a target notification connection address to a remote AE process. When the SQL function is called, the Netezza system sends a notification message to the remote AE, which then establishes a data connection.

The following setting indicates that the SQL function connects to a remote AE and does not launch a local AE. (The default is 0, which specifies launch and connect to a local AE.) This value can also be set by the –remote option of register_ae.

NZAE_REMOTE=1

The following setting is the required string name portion of the remote AE address. This can also be set by the --rname option of register_ae.

NZAE_REMOTE_NAME=MYREMOTEAE

The next three settings determine if dataslice ID, session ID, and transaction ID, respectively, are part of the remote AE address. (They can also be set by the --rdataslice, --rsession, and rtrans, respectively, option of register_ae.)The default for these three settings is ", denoting that they are not part of the address. On the remote AE side, the AE API is used to create an AE connection point, which is created using the same address settings that the NPS side is expecting. The remote AE then uses the AE API to "listen" with this connection point.

NZAE_REMOTE_NAME_DATA_SLICE= {0 | 1} 
NZAE_REMOTE_NAME_SESSION= {0 | 1} 
NZAE_REMOTE_NAME_TRANSACTION= {0 | 1}