DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getschemas  14 déc. 14Defects Propagation Dependencies

1     
2     /*
3     **  End of sp_jdbc_getschemas
4     */
5     
6     CREATE OR REPLACE PROCEDURE sp_jdbc_getschemas
7         @sp_qualifier varchar(32) = null, /* stored procedure qualifier*/
8         @sp_owner varchar(32) = null /* stored procedure owner */
9     as
10    
11        if @@trancount = 0
12        begin
13            set chained off
14        end
15    
16        if @sp_owner is null
17            select @sp_owner = '%'
18    
19        if @sp_qualifier is null
20            select @sp_qualifier = db_name()
21    
22        set transaction isolation level 1
23        /* this will make sure that all rows are sent even if
24        ** the client "set rowcount" is differect
25        */
26    
27        set rowcount 0
28    
29        select TABLE_SCHEM = name, TABLE_CATALOG = @sp_qualifier from
30            sysusers where suid >= - 2 and name like @sp_owner order by name
31    


exec sp_procxmode 'sp_jdbc_getschemas', 'AnyMode'
go

Grant Execute on sp_jdbc_getschemas to public
go
RESULT SETS
sp_jdbc_getschemas_rset_001

DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getschemas  
 MGTP 3 Grant to public sybsystemprocs..sysusers  
 QISO 3 Set isolation level 22
 MRST 2 Result Set Marker 29
 MTR1 2 Metrics: Comments Ratio Comments: 25% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 5 = 4dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 16 6

DATA PROPAGATION detailed
ColumnWritten To
@sp_qualifiersp_jdbc_getschemas_rset_001.TABLE_CATALOG

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_jdbc_getschemas_rset_001 
reads table sybsystemprocs..sysusers