DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getudts  14 déc. 14Defects Propagation Dependencies

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


exec sp_procxmode 'sp_jdbc_getudts', 'AnyMode'
go

Grant Execute on sp_jdbc_getudts to public
go
RESULT SETS
sp_jdbc_getudts_rset_001

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

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_jdbc_getudts_rset_001