Column | TDV JDBC Data Type | Nullable | Description |
PARAMETER_ID | INTEGER | Identifier of the parameter. Primary key. | |
PARAMETER_NAME | VARCHAR(255) | Name of the parameter. | |
DATA_TYPE | VARCHAR(255) | String representation of the data type. | |
DIRECTION | SMALLINT | Value indicates the parameter type: 0—Unknown 1—IN 2—INOUT 3—RESULT 4—OUT 5—RETURN | |
ORDINAL_POSITION | INTEGER | Yes | Position of the parameter in relation to other parameters in the same procedure. |
JDBC_DATA_TYPE | SMALLINT | JDBC/ODBC data types. For JDBC data types refer to: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Types.html. | |
PARAMETER_LENGTH | INTEGER | Yes | For a CHAR or VARCHAR parameter, the maximum length allowed; otherwise NULL. |
PARAMETER_PRECISION | INTEGER | Yes | Value is the number of digits for DECIMAL or NUMERIC data types. If the data type is not DECIMAL or NUMERIC, it is NULL. |
PARAMETER_SCALE | INTEGER | Yes | For a DECIMAL or NUMERIC data type, it is the number of digits. If the data type is not DECIMAL or NUMERIC, it is NULL. |
PAREMETER_RADIX | INTEGER | Yes | Value is 10 for all numeric data types. For non-numeric data types, it is NULL. |
NULLABLE | SMALLINT | Indicates whether the column is nullable: 0—NULL is not allowed. 1—NULL is allowed. 2—Unknown whether NULL is allowed or not. | |
IS_NULLABLE | VARCHAR(255) | Indicates whether the column is nullable: YES—Column is nullable. NO—Column is not nullable. Blank string is returned if it is not known. | |
PROCEDURE_ID | INTEGER | Identifier of the procedure. | |
PROCEDURE_NAME | VARCHAR(255) | Name of the procedure. | |
SCHEMA_ID | INTEGER | Yes | Identifier of the schema. |
SCHEMA_NAME | VARCHAR(255) | Yes | Name of the schema. |
CATALOG_ID | INTEGER | Yes | Identifier of the catalog. |
CATALOG_NAME | VARCHAR(255) | Yes | Name of the catalog. |
DATASOURCE_ID | INTEGER | Identifier of the data source. | |
DATASOURCE_NAME | VARCHAR(255) | Name of the data source. | |
BD_DATASOURCE_ NAME | VARCHAR(255) | BD name of the data source. | |
ANNOTATION | VARCHAR(2147483647) | Yes | Annotation for the parameter. |
OWNER_ID | INTEGER | Identifier of the person who created or owns the stored procedure in which the parameter is used. | |
OWNER | VARCHAR(255) | User name of the person who created or owns the procedure in which the parameter is used. | |
PARENT_PATH | VARCHAR(1043) | Path to the parent container. | |
BD_PARENT_PATH | VARCHAR(255) | BD path to the parent container. |