Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_getcrossreferences | 31 Aug 14 | Defects Dependencies |
1 2 3 /* 4 ** sp_ijdbc_getcrossreferences 5 */ 6 7 8 CREATE PROCEDURE sp_ijdbc_getcrossreferences 9 @pktable_qualifier varchar(32) = null, 10 @pktable_owner varchar(32) = null, 11 @pktable_name varchar(257), 12 @fktable_qualifier varchar(32) = null, 13 @fktable_owner varchar(32) = null, 14 @fktable_name varchar(257) 15 as 16 exec sp_ijdbc_fkeys 17 @pktable_name, @pktable_owner, @pktable_qualifier, 18 @fktable_name, @fktable_owner, @fktable_qualifier 19
exec sp_procxmode 'sp_ijdbc_getcrossreferences', 'AnyMode' go Grant Execute on sp_ijdbc_getcrossreferences to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getcrossreferences | |
MNER 3 No Error Check should check return value of exec | 16 |
MTR1 2 Metrics: Comments Ratio Comments: 6% | 8 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 | 8 |
MTR3 2 Metrics: Query Complexity Complexity: 2 | 8 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_ijdbc_fkeys calls proc sybsystemprocs..sp_getmessage reads table master..sysmessages (1) calls proc sybsystemprocs..sp_validlang reads table master..syslanguages (1) reads table sybsystemprocs..sysusermessages reads table master..syslanguages (1) read_writes table tempdb..#jpkeys (1) reads table sybsystemprocs..sysobjects read_writes table tempdb..#jfkeys (1) read_writes table tempdb..#jpid (1) read_writes table tempdb..#temp_keys (1) read_writes table tempdb..#jfid (1) reads table sybsystemprocs..sysindexes writes table tempdb..#tmp_fkeys (1) read_writes table tempdb..#jfkey_res (1) reads table sybsystemprocs..sysreferences |