Register UDXs in Netezza Performance Server databases

When you register a UDX by using the CREATE [OR REPLACE] [FUNCTION | AGGREGATE | LIBRARY] command, the command adds the UDX to the database and schema to which you are connected, or to the schema that you have specified. You cannot create a function in a database that is not your current database. The database is usually the one to which you are connected through the nzsql command, for example. You can register the UDXs to more than one database or schema, but the UDXs are accessible only to queries within that database unless you use cross-database access methods to run the UDXs.