DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getcrossreferences  31 Aug 14Defects Dependencies

1     /** SECTION END: CLEANUP **/
2     
3     
4     CREATE PROCEDURE sp_jdbc_getcrossreferences
5         @pktable_qualifier varchar(32) = null,
6         @pktable_owner varchar(32) = null,
7         @pktable_name varchar(255),
8         @fktable_qualifier varchar(32) = null,
9         @fktable_owner varchar(32) = null,
10        @fktable_name varchar(255)
11    as
12        /* this will make sure that all rows are sent even if
13        ** the client "set rowcount" is differect
14        */
15    
16        set rowcount 0
17    
18    
19        exec sp_jdbc_fkeys
20            @pktable_name, @pktable_owner, @pktable_qualifier,
21            @fktable_name, @fktable_owner, @fktable_qualifier
22    


exec sp_procxmode 'sp_jdbc_getcrossreferences', 'AnyMode'
go

Grant Execute on sp_jdbc_getcrossreferences to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getcrossreferences  
 MNER 3 No Error Check should check return value of exec 19
 MTR1 2 Metrics: Comments Ratio Comments: 16% 4
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 4
 MTR3 2 Metrics: Query Complexity Complexity: 3 4

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_jdbc_fkeys  
   reads table sybsystemprocs..sysobjects  
   reads table sybsystemprocs..sysindexes  
   read_writes table tempdb..#jfkeys (1) 
   reads table sybsystemprocs..sysreferences  
   read_writes table tempdb..#jfid (1) 
   read_writes table tempdb..#jfkey_res (1) 
   read_writes table tempdb..#jpid (1) 
   read_writes table tempdb..#jpkeys (1) 
   calls proc sybsystemprocs..sp_getmessage  
      calls proc sybsystemprocs..sp_validlang  
         reads table master..syslanguages (1)  
      reads table master..syslanguages (1)  
      reads table sybsystemprocs..sysusermessages  
      reads table master..sysmessages (1)