DatabaseTableApplicationCreatedLinks
sybsystemprocssp_jdbc_getfunctioncolumns_rset_001  01 janv. 70Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sp_jdbc_getfunctioncolumns_rset_001(-- 0 Rows, Data: 0 B, Index: 0 B
2         FUNCTION_CAT char(- 1) not null,
3         FUNCTION_SCHEM char(- 1) not null,
4         FUNCTION_NAME varchar(1) not null,
5         COLUMN_NAME longsysname(255) not null,
6         COLUMN_TYPE int not null,
7         DATA_TYPE smallint not null,
8         TYPE_NAME varchar(17) not null,
9         [PRECISION] int not null,
10        LENGTH int not null,
11        SCALE int not null,
12        RADIX smallint not null,
13        NULLABLE smallint not null,
14        REMARKS varchar(255) not null,
15        CHAR_OCTET_LENGTH int not null,
16        ORDINAL_POSITION smallint not null,
17        IS_NULLABLE varchar(0) not null,
18        SPECIFIC_NAME varchar(1) not null
19    )
20    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
FUNCTION_CAT temptable_D1.FUNCTION_CAT
FUNCTION_SCHEM temptable_D1.FUNCTION_SCHEM
FUNCTION_NAME temptable_D1.FUNCTION_NAME
COLUMN_NAME temptable_D1.COLUMN_NAME
COLUMN_TYPE temptable_D1.COLUMN_TYPE
DATA_TYPE temptable_D1.DATA_TYPE
TYPE_NAME temptable_D1.TYPE_NAME
PRECISION temptable_D1.PRECISION
LENGTH temptable_D1.LENGTH
SCALE temptable_D1.SCALE
RADIX temptable_D1.RADIX
NULLABLE temptable_D1.NULLABLE
REMARKS temptable_D1.REMARKS
CHAR_OCTET_LENGTH temptable_D1.CHAR_OCTET_LENGTH
ORDINAL_POSITION temptable_D1.ORDINAL_POSITION
IS_NULLABLE temptable_D1.IS_NULLABLE
SPECIFIC_NAME temptable_D1.SPECIFIC_NAME

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_jdbc_getfunctioncolumns