Columns in the ResultSets returned by getFunctionColumns and getProcedureColumns are as described by the API.
The following table shows Derby-specific details for some specific columns returned by getFunctionColumns.
| Column | Description |
|---|---|
| COLUMN_TYPE | A short indicating what the row describes. Is always DatabaseMetaData.functionColumnIn if it represents a parameter; DatabaseMetaData.functionReturn if it represents a return value; and DatabaseMetaData.functionColumnResult if it represents a column in a table function. |
| TYPE_NAME | Derby-specific name for the type. |
| NULLABLE | Always returns DatabaseMetaData.functionNullable. |
| REMARKS | A String which describes the Java type of the method parameter. |
| ORDINAL_POSITION | The ordinal position, starting from 1, for the input and output parameters for the function. |
| METHOD_ID | A Derby-specific column. |
| PARAMETER_ID | A Derby-specific column. |
The following table shows Derby-specific details for some specific columns returned by getProcedureColumns.
| Column | Description |
|---|---|
| COLUMN_TYPE | A short indicating what the row describes. Is always DatabaseMetaData.procedureColumnIn if the parameter is (possibly implicitly) declared as an IN parameter; DatabaseMetaData.procedureColumnInOut if the parameter is declared as an INOUT parameter; and DatabaseMetaData.procedureColumnOut if the parameter is declared as an OUT parameter. |
| TYPE_NAME | Derby-specific name for the type. |
| NULLABLE | Always returns DatabaseMetaData.procedureNullable. |
| REMARKS | A String which describes the Java type of the method parameter. |
| ORDINAL_POSITION | The ordinal position, starting from 1, for the input and output parameters for the procedure. |
| METHOD_ID | A Derby-specific column. |
| PARAMETER_ID | A Derby-specific column. |