DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_getcrossreferences  31 Aug 14Defects 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