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
Start of change-370End of change
Start of changeXMLEnd of change
17
DISTINCT
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
Start of changeXMLEnd of change
Start of changeXMLEnd of change
Qualified Type Name
DISTINCT
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 Start of changeVARGRAPHIC(2000) CCSID 1200

Nullable

End of change
A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

COLUMN_DEF VARCHAR(1)

Nullable

The default value for the column.

Contains the null value if there is no default value.

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
Start of change-370End of change
Start of changeXMLEnd of change
17
DISTINCT
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 or NCHAR
–2
CHARACTER FOR BIT DATA or BINARY
12
VARCHAR or VARGRAPHIC or NVARCHAR
–3
VARCHAR FOR BIT DATA or VARBINARY
2005
CLOB or DBCLOB or NCLOB
2004
BLOB
91
DATE
92
TIME
93
TIMESTAMP
70
DATALINK
1111
ROWID
Start of change2009End of change
Start of changeXMLEnd of change
2001
DISTINCT
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
Start of change-370End of change
Start of changeXMLEnd of change
2001
DISTINCT