Database | Proc | Application | Created | Links |
sybsystemprocs | sp_jdbc_getcatalogs | 31 Aug 14 | Defects 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) |