Database	Proc	Application	Created	Links
sybsystemprocs	sp_jdbc_getschemas		31 Aug 14	Defects Dependencies

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

exec sp_procxmode 'sp_jdbc_getschemas', 'AnyMode'
go

Grant Execute on sp_jdbc_getschemas to public
go

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

DEPENDENCIES

PROCS AND TABLES USED reads table sybsystemprocs..sysusers