Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_exportkey | 31 Aug 14 | Defects Dependencies |
1 2 3 /* 4 ** sp_ijdbc_exportkey 5 */ 6 7 CREATE PROCEDURE sp_ijdbc_exportkey( 8 @table_qualifier varchar(32) = null, 9 @table_owner varchar(32) = null, 10 @table_name varchar(257)) 11 as 12 exec sp_ijdbc_fkeys 13 @table_name, @table_owner, @table_qualifier, NULL, NULL, NULL 14
exec sp_procxmode 'sp_ijdbc_exportkey', 'AnyMode' go Grant Execute on sp_ijdbc_exportkey to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_exportkey | |
MNER 3 No Error Check should check return value of exec | 12 |
MUCO 3 Useless Code Useless Brackets in create proc | 7 |
MTR1 2 Metrics: Comments Ratio Comments: 5% | 7 |
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 | 7 |
MTR3 2 Metrics: Query Complexity Complexity: 2 | 7 |
DEPENDENCIES |
PROCS AND TABLES USED calls proc sybsystemprocs..sp_ijdbc_fkeys 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) 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) reads table sybsystemprocs..sysindexes writes table tempdb..#tmp_fkeys (1) read_writes table tempdb..#jfkey_res (1) reads table sybsystemprocs..sysreferences |