DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_getudts  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /* 
4     ** JDBC 2.0
5     ** 
6     ** DatabaseMetaData.getUDTs(catalog, schema, typeNamePattern, int types[])
7     **
8     ** NOT SUPPORTED
9     */
10    create or replace procedure sp_ijdbc_getudts(
11        @table_qualifier varchar(128) = NULL,
12        @table_owner varchar(128) = NULL,
13        @type_name_pattern varchar(128),
14        @types varchar(128))
15    as
16        declare @empty_string varchar(1)
17        declare @empty_int int
18    
19        select @empty_string = ''
20        select @empty_int = 0
21    
22        /* not supported, return an empty result set */
23        select
24            TYPE_CAT = @empty_string,
25            TYPE_SCHEM = @empty_string,
26            TYPE_NAME = @empty_string,
27            CLASS_NAME = @empty_string,
28            DATA_TYPE = @empty_int,
29            REMARKS = @empty_string
30        where
31            1 = 2
32    


exec sp_procxmode 'sp_ijdbc_getudts', 'AnyMode'
go

Grant Execute on sp_ijdbc_getudts to public
go
RESULT SETS
sp_ijdbc_getudts_rset_001

DEFECTS
 MEST 4 Empty String will be replaced by Single Space 19
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getudts  
 MUCO 3 Useless Code Useless Brackets in create proc 10
 QPNC 3 No column in condition 31
 MRST 2 Result Set Marker 23
 MTR1 2 Metrics: Comments Ratio Comments: 15% 10
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 10
 MTR3 2 Metrics: Query Complexity Complexity: 7 10

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_ijdbc_getudts_rset_001