DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getcatalogs  31 Aug 14Defects Dependencies

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


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 12
 MRST 2 Result Set Marker 19
 MTR1 2 Metrics: Comments Ratio Comments: 25% 4
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 4
 MTR3 2 Metrics: Query Complexity Complexity: 8 4

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