nzLua API

The nzLua API defines how nzLua interacts with the Netezza database. nzLua can be used to create functions, aggregates, and table functions.

Each type of UDX has a specific set of API calls associated with it. In addition, all types of nzLua UDX have a common set of API calls. The documentation for the API calls is therefore broken down into the following sections.
  • API calls common to all nzLua programs
  • API calls used by a UDF (user-defined function)
  • API calls used by a UDA (user-defined aggregate)
  • API calls used by a UDTF (user-defined table function)
  • SPUPad API (save results in memory, retrieve with another UDX)
  • Global variables
  • Constants

The abbreviation UDX is generally used as a shorthand method to represent the term "user defined X" where X can be one of [function | aggregate | table function].