PL/MX function attributes

Name

The name of the PL/MX function.

Metadata UID

The unique identification number of the PL/MX function.

SQL Access

Specifies how the PL/MX function accesses SQL data. If the function does not perform SQL operations, the value is N. If the function performs SQL operations, then the following values are displayed: CONTAINS SQL, MODIFIES SQL DATA, or READS SQL DATA.

Parameters

The parameter type.

UDR Type

The user-defined routine (UDR) type. The value is PL/MX Function.

Deterministic

Indicates if the function is DETERMINISTIC or NOT DETERMINISTIC. The values are Yes and No. The default value is No.

If the function is DETERMINISTIC, it always returns the same values for OUT and INOUT parameters for a given set of argument values. If the function is NOT DETERMINISTIC, it does not return the same values. SQL/MX supports both options, but always treats the function as NOT DETERMINISTIC.

Isolate

Indicates if the function is ISOLATE or NO ISOLATE. The values are Yes and No. The default value is Yes.

SQL/MX supports both options, but always executes the function in the SQL/MX UDR Server process (ISOLATE).

Isolation Level

The isolation level for the PL/MX routine. The value is R for

COM_RESTRICTED_ISOLATION_LEVEL.

Return Type

This field is displayed only for PL/MX functions. The SQL datatype that is returned.

Transaction Attributes

Indicates if a transaction is required.

Creation Time

The time and date when the PL/MX function is created.

Redefinition Time

The time and date when the PL/MX function is last redefined.

Owner

The owner of the PL/MX function.