8.6.32 getFunctions(String catalog, String schemaPattern, String functionNamePattern)

(1) Function

This method returns information about the function.

To Page Top

(2) Format

public synchronized ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException

To Page Top

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schemaPattern

Specifies a schema name pattern. This argument is case sensitive.

String functionNamePattern

Specifies a function name pattern. This argument is case sensitive.

To Page Top

(4) Return value

This method always returns a ResultSet object that contains no rows of retrieval results The following table shows the format of the ResultSet object that is returned.

Table 8‒52: Format of the ResultSet object that is returned

Column No.	Type	Column name	Description
1	String	FUNCTION_CAT	Catalog name
2	String	FUNCTION_SCHEM	Authorization identifier name
3	String	FUNCTION_NAME	Function name
4	String	REMARKS	Description of function
5	short	FUNCTION_TYPE	Function type
6	String	SPECIFIC_NAME	Name that uniquely identifies this function within the schema

To Page Top

(5) Exceptions

If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.

To Page Top