sqlj.unsetUDTextName
Argument | Description | Restrictions | Syntax |
---|---|---|---|
data_type | User-defined data type for which to remove the mapping | Must exist | Identifier |
This routine removes the SQL-to-Java mapping and consequently removes any cached copy of the Java™ class from shared memory of the database server.
The unsetUDTextName( ) routine is an extension to the SQLJ:SQL Routines Using the Java™ Programming Language specification.
If the IFX_EXTEND_ROLE configuration parameter is enabled (which is its default setting), only the DBSA or users who hold the EXTEND role are able to execute the unsetUDTextName( ) procedure. When IFX_EXTEND_ROLE is disabled, any user can execute unsetUDTextName( ). (But regardless of the IFX_EXTEND_ROLE setting, you must hold the Resource privilege or the DBA privilege on the database, and also hold the Usage privilege on the Java™ language, before you can create or drop a Java™ UDR.)