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.)