The Procedure Parameters schema returns information about Parameters of any STORED PROCEDURE or EXTERNAL STORED PROCEDURE objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.COLUMNS[V] or DBC.COLUMNS[V]X Data Dictionary view based on UseXViews Connection setting.

Column Name	Data Type	Description
Id	String	Returns a unique Id for the PROCEDURE parameter.
Name	String	Returns the name of the PROCEDURE parameter.
Ordinal	Int32	Returns the position of the column in the TABLE.
ParameterType	TypeSpecification
ParameterType.TypeName	String	Returns the SQL Data Type name. TypeName will return the User Defined Type name if the column is a UDT.
ParameterType.MaxLength	Int32?	Returns the maximum length of the Column for the following Data Types: BYTE or VARBYTE CHAR or VARCHAR BLOB or CLOB Time With Time Zone All Interval Data Types All Period Types
ParameterType.Precision	Int32?	Returns information about the maximum number of digits (base 10) that can be stored in a Numeric data type: ByteInt, SmallInt, Integer and BigInt Decimal or Numeric Float or Double Precision
ParameterType.DateTimePrecision	Int32?	Returns information about the maximum numbers of fractional seconds to the right of the decimal point for the following data types: Timestamp and Timestamp With Time Zone Time and Time With Time Zone Interval Day To Second Interval Hour To Second Interval Minute To Second Interval Second
ParameterType.Scale	Int32?	Returns information about the maximum number of fractional digits (base 10) to the right of the decimal point for Decimal data type.
IsMultiSet	Boolean	This field is always set to False.
Mode	String	Returns information about the parameter mode: IN OUT INOUT
Default	String	Returns any default value assigned to the parameter.