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
orNOT DETERMINISTIC
. The values are Yes and No. The default value is No.If the function is
DETERMINISTIC
, it always returns the same values forOUT
andINOUT
parameters for a given set of argument values. If the function isNOT DETERMINISTIC
, it does not return the same values. SQL/MX supports both options, but always treats the function asNOT DETERMINISTIC
. - Isolate
-
Indicates if the function is
ISOLATE
orNO 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.