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

1     
2     /** SECTION END: CLEANUP **/
3     
4     create procedure sp_jdbc_getsupertables(
5         @table_qualifier varchar(32) = NULL,
6         @table_owner varchar(32),
7         @table_name_pattern varchar(255))
8     
9     as
10        declare @empty_string varchar(1)
11    
12        select @empty_string = ''
13    
14        /* Return an empty result set */
15        select
16            TABLE_CAT = convert(varchar, @empty_string),
17            TABLE_SCHEM = convert(varchar, @empty_string),
18            TABLE_NAME = convert(varchar, @empty_string),
19            SUPERTABLE_NAME = convert(varchar, @empty_string)
20        where
21            1 = 2
22    

exec sp_procxmode 'sp_jdbc_getsupertables', 'AnyMode'
go

Grant Execute on sp_jdbc_getsupertables to public
go

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