Managing UDFs and their properties

The following management operations are supported on UDFs. To execute these operations, log on to NonStop SQL/MX.
  • Creating a UDF - Execute the CREATE FUNCTION statement.

  • Dropping a UDF - Execute the DROP FUNCTION statement.

  • Securing a UDF - Execute the GRANT EXECUTE, GRANT...(for UDF executable or source), REVOKE EXECUTE, or REVOKE....(for UDF executable or source) statement.

  • Transferring ownership of a UDF - Execute the GIVE Object command.

  • Viewing a UDF - Execute the SHOWDDL command.

For information on statements and commands, see the SQL/MX Reference Manual.