DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getcatalogs  14 déc. 14Defects Propagation Dependencies

1     
2     CREATE OR REPLACE PROCEDURE sp_jdbc_getcatalogs
3     as
4     
5         if @@trancount = 0
6         begin
7             set chained off
8         end
9     
10        set transaction isolation level 1
11        /* this will make sure that all rows are sent even if
12        ** the client "set rowcount" is differect
13        */
14    
15        set rowcount 0
16    
17        select TABLE_CAT = name from master..sysdatabases order by name
18    


exec sp_procxmode 'sp_jdbc_getcatalogs', 'AnyMode'
go

Grant Execute on sp_jdbc_getcatalogs to public
go
RESULT SETS
sp_jdbc_getcatalogs_rset_001

DEFECTS
 MGTP 3 Grant to public master..sysdatabases  
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getcatalogs  
 QISO 3 Set isolation level 10
 MRST 2 Result Set Marker 17
 MTR1 2 Metrics: Comments Ratio Comments: 20% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 8 2

DEPENDENCIES
PROCS AND TABLES USED
reads table master..sysdatabases (1)  
writes table sybsystemprocs..sp_jdbc_getcatalogs_rset_001