IDA LISTUDXS command

The IDA LISTUDXS CLPPlus command lists the signatures of all the UDXs owned by the current user or, if issued by an administrator, the signatures of all the UDXs in the system.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

CLPPlus must be connected to the database.

Command syntax

IDA LISTUDXS

Read syntax diagramSkip visual syntax diagramIDA LISTUDXS

Parameters

There are no parameters for this command.

Examples

The following command lists all the UDXS of the current user:
SQL> IDA LISTUDXS

UDX
---------------
XAVG(INTEGER)
UDTFSMALL(SMALLINT)
UDF2(INTEGER,INTEGER)