DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getsupertables  14 déc. 14Defects Propagation Dependencies

1     
2     /* end of dbo.sp_jdbc_getsupertypes */
3     
4     
5     /* Don't delete the following line. This is where sp_jdbc_getsupertables get inserted. */
6     /*** ADDPOINT_SUPERTABLES ***/
7     
8     /* 
9     ** JDBC 3.0
10    ** 
11    ** DatabaseMetaData.getSuperTables(catalog, schemaPattern, tableNamePattern)
12    **
13    */
14    
15    create or replace procedure sp_jdbc_getsupertables(
16        @table_qualifier varchar(32) = NULL,
17        @table_owner varchar(32),
18        @table_name_pattern varchar(255))
19    
20    as
21        declare @empty_string varchar(1)
22    
23        select @empty_string = ''
24    
25        /* Return an empty result set */
26        select
27            TABLE_CAT = convert(varchar, @empty_string),
28            TABLE_SCHEM = convert(varchar, @empty_string),
29            TABLE_NAME = convert(varchar, @empty_string),
30            SUPERTABLE_NAME = convert(varchar, @empty_string)
31        where
32            1 = 2
33    


exec sp_procxmode 'sp_jdbc_getsupertables', 'AnyMode'
go

Grant Execute on sp_jdbc_getsupertables to public
go
RESULT SETS
sp_jdbc_getsupertables_rset_001

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

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_jdbc_getsupertables_rset_001