IBM PureData System for Analytics, Version 7.1

Netezza SQL reference

This section provides reference information for the IBM® Netezza® SQL commands that relate to the creation and management of user-defined functions and aggregates.

If you issue an alter, create, or drop command for a UDX or shared library that is in use by an active query, the Netezza system waits for that transaction to complete before it runs the command.

This publication also describes other Netezza SQL commands such as GRANT, REVOKE, and COMMENT. For a description of these commands, see the IBM Netezza Database User’s Guide.

ALTER AGGREGATE
Use the ALTER AGGREGATE command to change the aggregate object files, state, return value, memory usage options, or logging level.
ALTER FUNCTION
Use the ALTER FUNCTION command to change the function object files, return value, memory usage options, or logging level. You can also use this command to change the owner of the UDF.
ALTER LIBRARY
Use the ALTER LIBRARY command to change a user-defined shared library. You can use this command to change properties such as the loading method, dependencies, owner, and object files.
CREATE [OR REPLACE] AGGREGATE
Use the CREATE AGGREGATE command to create a user-defined aggregate. Use CREATE OR REPLACE AGGREGATE to create an aggregate or to update an existing aggregate with new object files, state, return value, memory usage, or logging level.
CREATE [OR REPLACE] FUNCTION
Use the CREATE FUNCTION command to create a user-defined function. The CREATE OR REPLACE FUNCTION creates a function or replaces an existing function of the same name with new object files, return value, function behaviors, or logging level.
CREATE [OR REPLACE] LIBRARY
Use the CREATE [OR REPLACE] LIBRARY command to create a user-defined shared library. After the library is added to the database, it is immediately available for use by a UDX.
DROP AGGREGATE
Use the DROP AGGREGATE command to remove an existing user-defined aggregate from a database. When you drop an aggregate, the aggregate object files are also removed from the user code object repository.
DROP FUNCTION
Use the DROP FUNCTION command to remove an existing user-defined function from a database. When you drop a function, the function object files are also removed from the user code object repository.
DROP LIBRARY
Use the DROP LIBRARY command to remove an existing user-defined shared library from a database. When you drop a shared library, the shared library object files are also removed from the user code object repository.
SHOW AGGREGATE
Use the SHOW AGGREGATE command to display information about one or more aggregates (built-in and UDAs). The command checks your user account privileges to ensure that you are permitted to see information about the UDAs defined in the database and schema.
SHOW FUNCTION
Use the SHOW FUNCTION command to display information about one or more functions (built-in and UDFs). The command checks your user account privileges to ensure that you are permitted to see information about the UDFs defined in the database and schema.
SHOW LIBRARY
Use the SHOW LIBRARY command to display information about one or more user-defined shared libraries. The command checks your user account privileges to ensure that you are permitted to see information about the shared libraries that are defined in the database and schema.