Database	Proc	Application	Created	Links
sybsystemprocs	sp_jdbc_getudts		31 Aug 14	Defects Dependencies

1     /** SECTION END: CLEANUP **/
2     create procedure sp_jdbc_getudts(
3         @table_qualifier varchar(32) = NULL,
4         @table_owner varchar(32) = NULL,
5         @type_name_pattern varchar(255),
6         @types varchar(255))
7     as
8         declare @empty_string varchar(1)
9         declare @empty_int int
10    
11        select @empty_string = ''
12        select @empty_int = 0
13    
14        /* not supported, return an empty result set */
15        select
16            TYPE_CAT = @empty_string,
17            TYPE_SCHEM = @empty_string,
18            TYPE_NAME = @empty_string,
19            CLASS_NAME = @empty_string,
20            DATA_TYPE = @empty_int,
21            REMARKS = @empty_string
22        where
23            1 = 2
24    

exec sp_procxmode 'sp_jdbc_getudts', 'AnyMode'
go

Grant Execute on sp_jdbc_getudts to public
go

DEFECTS
MEST 4 Empty String will be replaced by Single Space	11
MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getudts
MUCO 3 Useless Code Useless Brackets in create proc	2
QPNC 3 No column in condition	23
VUNU 3 Variable is not used @table_qualifier	3
VUNU 3 Variable is not used @table_owner	4
VUNU 3 Variable is not used @type_name_pattern	5
VUNU 3 Variable is not used @types	6
MRST 2 Result Set Marker	15
MTR1 2 Metrics: Comments Ratio Comments: 9%	2
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	2
MTR3 2 Metrics: Query Complexity Complexity: 7	2