SQLFUNCTIONCOLS

The SQLFUNCTIONCOLS view contains one row for every parameter of a function. The result of a scalar function and the result columns of a table function are also returned.

The following table describes the columns in the view:

Table 1. SQLFUNCTIONCOLS view
Column Name	Data Type	Description
FUNCTION_CAT	VARCHAR(128)	Relational database name
FUNCTION_SCHEM	VARCHAR(128)	Schema name of the function instance.
FUNCTION_NAME	VARCHAR(128)	Name of the function instance.
COLUMN_NAME	VARCHAR(128) Nullable	Name of a function parameter. Contains the null value if the parameter does not have a name.
COLUMN_TYPE	SMALLINT	Type of the parameter: 1 IN 4 RETURN value 5 Result column of a table function
DATA_TYPE	SMALLINT	The data type of the parameter: –5 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL -360 DECFLOAT 1 CHARACTER –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY -99 CLOB –95 GRAPHIC or –96 VARGRAPHIC –350 DBCLOB –8 NCHAR –9 NVARCHAR –10 NCLOB -98 BLOB 91 DATE 92 TIME 93 TIMESTAMP 70 DATALINK –100 ROWID -370 XML 17 DISTINCT 50 ARRAY
TYPE_NAME	VARCHAR(261)	The name of the data type of the parameter: BIGINT BIGINT INTeger INTEGER SMALLINT SMALLINT DECIMAL DECIMAL NUMERIC NUMERIC FLOAT DOUBLE PRECISION REAL REAL DECFLOAT DECFLOAT CHARacter CHARACTER CHARacter FOR BIT DATA CHARACTER FOR BIT DATA VARCHAR VARCHAR VARCHAR FOR BIT DATA VARCHAR FOR BIT DATA CLOB CLOB GRAPHIC GRAPHIC VARGRAPHIC VARGRAPHIC DBCLOB DBCLOB NCHAR NCHAR NVARCHAR NVARCHAR NCLOB NCLOB BINARY BINARY VARBINARY VARBINARY BLOB BLOB DATE DATE TIME TIME TIMESTAMP TIMESTAMP DATALINK DATALINK ROWID ROWID XML XML Qualified Type Name DISTINCT Array Type Name ARRAY
COLUMN_SIZE	INTEGER	Length of the parameter.
BUFFER_LENGTH	INTEGER	Indicates the length of the parameter in a buffer.
DECIMAL_DIGITS	SMALLINT Nullable	Scale of numeric or datetime data. Contains the null value if the parameter is not decimal, numeric, binary, time or timestamp.
NUM_PREC_RADIX	SMALLINT Nullable	Indicates if the precision specified in column NUMERIC_PRECISION is specified as a number of binary or decimal digits: 2 Binary; floating-point precision is specified in binary digits. 10 Decimal; all other numeric types are specified in decimal digits. Contains the null value if the parameter is not numeric.
NULLABLE	SMALLINT	Indicates whether the parameter is nullable. 0 The parameter does not allow nulls. 1 The parameter does allow nulls.
REMARKS	VARGRAPHIC(2000) CCSID 1200 Nullable	A character string supplied with the COMMENT statement. Contains the null value if there is no long comment.
COLUMN_DEF	DBCLOB(64K) CCSID 1200 Nullable	The expression string used to calculate the default value of a parameter, if one exists. If the default value is the null value, the expression string is the keyword NULL. Contains the null value if the parameter has no default.
SQL_DATA_TYPE	SMALLINT	The SQL data type of the parameter: –5 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL -360 DECFLOAT 1 CHARACTER –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY -99 CLOB –95 GRAPHIC –96 VARGRAPHIC –350 DBCLOB –8 NCHAR –9 NVARCHAR –10 NCLOB -98 BLOB 9 DATE 9 TIME 9 TIMESTAMP 70 DATALINK –100 ROWID -370 XML 17 DISTINCT 50 ARRAY
SQL_DATETIME_SUB	SMALLINT Nullable	The datetime subtype of the parameter: 1 DATE 2 TIME 3 TIMESTAMP Contains the null value if the data type is not a datetime data type.
CHAR_OCTET_LENGTH	INTEGER Nullable	Indicates the length in characters of the parameter. Contains the null value if the column is not a string.
ORDINAL_POSITION	INTEGER	Numeric place of the parameter in the parameter list, ordered from left to right. For scalar functions, the result of the function has a value of 0. For table functions, the result columns are numbered from 1 (leftmost result column) to n (nth result column).
IS_NULLABLE	VARCHAR(3)	Indicates whether the parameter is nullable. NO The parameter does not allow nulls. YES The parameter does allow nulls.
SPECIFIC_NAME	VARCHAR(128)	Specific name of the function instance
JDBC_DATA_TYPE	INTEGER	The JDBC data type of the parameter: –5 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL 1111 DECFLOAT 1 CHARACTER or GRAPHIC -15 NCHAR –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR or VARGRAPHIC -9 NVARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY 2005 CLOB or DBCLOB 2011 NCLOB 2004 BLOB 91 DATE 92 TIME 93 TIMESTAMP 70 DATALINK -8 ROWID 2009 XML 2001 DISTINCT 2003 ARRAY
I_DATA_TYPE	INTEGER	Indicates the IBM® i CLI data type of the parameter. 19 BIGINT 4 INTEGER 5 SMALLINT 3 DECIMAL 2 NUMERIC 8 DOUBLE PRECISION 7 REAL -360 DECFLOAT 1 CHARACTER –2 CHARACTER FOR BIT DATA or BINARY 12 VARCHAR –3 VARCHAR FOR BIT DATA or VARBINARY 14 CLOB 95 GRAPHIC or NCHAR 96 VARGRAPHIC or NVARCHAR 15 DBCLOB or NCLOB 13 BLOB 91 DATE 92 TIME 93 TIMESTAMP 16 DATALINK 1111 ROWID -370 XML 2001 DISTINCT 50 ARRAY
SOURCE_DATA_TYPE	SMALLINT Nullable	The source data type if the data type of the parameter is a distinct type. For values see JDBC_DATA_TYPE. Contains the null value if the data type is not a distinct type.
SOURCE_TYPE_NAME	VARCHAR(128) Nullable	If the parameter data type is a user-defined type, the built-in data type name of its source type. Contains the null value if the parameter data type is not a user-defined type.
SOURCE_SQL_DATA_TYPE	SMALLINT Nullable	If the parameter data type is a user-defined type, the built-in SQL_DATA_TYPE of its source type. For values see SQL_DATA_TYPE. Contains the null value if the parameter data type is not a user-defined type.
SOURCE_JDBC_DATA_TYPE	SMALLINT Nullable	If the parameter data type is a user-defined type, the built-in JDBC_DATA_TYPE of its source type. For values see JDBC_DATA_TYPE. Contains the null value if the parameter data type is not a user-defined type.
MAXIMUM_CARDINALITY	BIGINT Nullable	The maximum cardinality of the array data type. Contains the null value if the type is not an array type.