Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_importkey | 31 Aug 14 | Defects Dependencies |
1 2 3 /* 4 ** sp_ijdbc_importkey 5 */ 6 7 8 CREATE PROCEDURE sp_ijdbc_importkey( 9 @table_qualifier varchar(32) = null, 10 @table_owner varchar(32) = null, 11 @table_name varchar(257)) 12 as 13 exec sp_ijdbc_fkeys 14 NULL, NULL, NULL, @table_name, @table_owner, @table_qualifier 15
exec sp_procxmode 'sp_ijdbc_importkey', 'AnyMode' go Grant Execute on sp_ijdbc_importkey to public go
DEFECTS | |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_importkey | |
MNER 3 No Error Check should check return value of exec | 13 |
MUCO 3 Useless Code Useless Brackets in create proc | 8 |
MTR1 2 Metrics: Comments Ratio Comments: 5% | 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 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 |