Registering analytic executables

An AE is connected to the NPS by a SQL function registration. This registration can be a scalar, table, or aggregate function. A single AE can be registered with different signatures (that is as more than one function).

For example, a specific executable can be registered as both a scalar and a table function, with the AE operating properly based on the registration/invocation used. An AE installation includes a command-line utility that is called register_ae, which is used to associate SQL functions with AEs. In addition, register_ae sets the following properties of the function:
  • Type of SQL function, either scalar, table, or aggregate.
  • The signature of the function by using input arguments.
  • The function return value type or return table definition.
Use the register_ae option --help to display help about usage and options. The basic syntax of register_ae is: 
register_ae <options>
Note: Most of the options begin with two hyphens: “--” which might be difficult to view in various screen-based documentation formats.