DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getcrossreferences  14 déc. 14Defects Propagation Dependencies

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


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 17
 MTR1 2 Metrics: Comments Ratio Comments: 13% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 3 2

DATA PROPAGATION detailed
ColumnWritten To
@fktable_qualifiersp_jdbc_fkeys_rset_001.FKTABLE_CAT sp_jdbc_fkeys_rset_002.FKTABLE_CAT sp_jdbc_fkeys_rset_003.FKTABLE_CAT
@pktable_qualifiersp_jdbc_fkeys_rset_001.PKTABLE_CAT sp_jdbc_fkeys_rset_002.PKTABLE_CAT sp_jdbc_fkeys_rset_003.PKTABLE_CAT

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