DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_exportkey  31 Aug 14Defects Dependencies

1     /** SECTION END: CLEANUP **/
2     
3     
4     CREATE PROCEDURE sp_jdbc_exportkey(
5         @table_qualifier varchar(32) = null,
6         @table_owner varchar(32) = null,
7         @table_name varchar(255))
8     as
9         /* this will make sure that all rows are sent even if
10        ** the client "set rowcount" is differect
11        */
12    
13        set rowcount 0
14    
15        exec sp_jdbc_fkeys
16            @table_name, @table_owner, @table_qualifier, NULL, NULL, NULL
17    


exec sp_procxmode 'sp_jdbc_exportkey', 'AnyMode'
go

Grant Execute on sp_jdbc_exportkey to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_exportkey  
 MNER 3 No Error Check should check return value of exec 15
 MUCO 3 Useless Code Useless Brackets in create proc 4
 MTR1 2 Metrics: Comments Ratio Comments: 25% 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)