DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_getlob  14 déc. 14Defects Propagation Dependencies

1     
2     
3     create or replace procedure sp_jdbc_getlob(
4         @lob_type int,
5         @locator binary(24),
6         @read_pos bigint = 0,
7         @read_len int = - 1)
8     as
9         if @lob_type = 0
10        begin
11            if @read_len < 0
12                select return_lob(IMAGE, @locator)
13            else
14                select return_lob(IMAGE, substring(locator_literal(IMAGE_locator, @locator), @read_pos, @read_len))
15        end
16        else if @lob_type = 1
17        begin
18            if @read_len < 0
19                select return_lob(TEXT, @locator)
20            else
21                select return_lob(TEXT, substring(locator_literal(TEXT_locator, @locator), @read_pos, @read_len))
22        end
23        else
24        begin
25            if @read_len < 0
26                select return_lob(UNITEXT, @locator)
27            else
28                select return_lob(UNITEXT, substring(locator_literal(UNITEXT_locator, @locator), @read_pos, @read_len))
29        end
30    


exec sp_procxmode 'sp_jdbc_getlob', 'AnyMode'
go

Grant Execute on sp_jdbc_getlob to public
go
RESULT SETS
sp_jdbc_getlob_rset_006
sp_jdbc_getlob_rset_005
sp_jdbc_getlob_rset_004
sp_jdbc_getlob_rset_003
sp_jdbc_getlob_rset_002
sp_jdbc_getlob_rset_001

DEFECTS
 PERR 6 Parsing Error Could not find COLUMN IMAGE in the query's tables 12
 PERR 6 Parsing Error Could not find COLUMN IMAGE in the query's tables 14
 PERR 6 Parsing Error Could not find COLUMN IMAGE_locator in the query's tables 14
 PERR 6 Parsing Error Could not find COLUMN TEXT in the query's tables 19
 PERR 6 Parsing Error Could not find COLUMN TEXT in the query's tables 21
 PERR 6 Parsing Error Could not find COLUMN TEXT_locator in the query's tables 21
 PERR 6 Parsing Error Could not find COLUMN UNITEXT in the query's tables 26
 PERR 6 Parsing Error Could not find COLUMN UNITEXT in the query's tables 28
 PERR 6 Parsing Error Could not find COLUMN UNITEXT_locator in the query's tables 28
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_getlob  
 MUCO 3 Useless Code Useless Brackets in create proc 3
 QCRS 3 Conditional Result Set 12
 QCRS 3 Conditional Result Set 14
 QCRS 3 Conditional Result Set 19
 QCRS 3 Conditional Result Set 21
 QCRS 3 Conditional Result Set 26
 QCRS 3 Conditional Result Set 28
 QNAM 3 Select expression has no name return_lob(IMAGE, @locator) 12
 QNAM 3 Select expression has no name return_lob(IMAGE, substring(locator_literal(IMAGE_locator, @locator), @read_pos, @read_len)) 14
 QNAM 3 Select expression has no name return_lob(TEXT, @locator) 19
 QNAM 3 Select expression has no name return_lob(TEXT, substring(locator_literal(TEXT_locator, @locator), @read_pos, @read_len)) 21
 QNAM 3 Select expression has no name return_lob(UNITEXT, @locator) 26
 QNAM 3 Select expression has no name return_lob(UNITEXT, substring(locator_literal(UNITEXT_locator, @locator), @read_pos, @read_len)) 28
 MRST 2 Result Set Marker 12
 MRST 2 Result Set Marker 14
 MRST 2 Result Set Marker 19
 MRST 2 Result Set Marker 21
 MRST 2 Result Set Marker 26
 MRST 2 Result Set Marker 28
 MTR1 2 Metrics: Comments Ratio Comments: 0% 3
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 7 = 6dec - 1exi + 2 3
 MTR3 2 Metrics: Query Complexity Complexity: 17 3

DATA PROPAGATION detailed
ColumnWritten To
@locatorsp_jdbc_getlob_rset_001.sqlbNoName41 sp_jdbc_getlob_rset_002.sqlbNoName42 sp_jdbc_getlob_rset_003.sqlbNoName43 sp_jdbc_getlob_rset_004.sqlbNoName44 sp_jdbc_getlob_rset_005.sqlbNoName45 sp_jdbc_getlob_rset_006.sqlbNoName46
@read_lensp_jdbc_getlob_rset_001.sqlbNoName41 sp_jdbc_getlob_rset_003.sqlbNoName43 sp_jdbc_getlob_rset_005.sqlbNoName45
@read_possp_jdbc_getlob_rset_001.sqlbNoName41 sp_jdbc_getlob_rset_003.sqlbNoName43 sp_jdbc_getlob_rset_005.sqlbNoName45

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_jdbc_getlob_rset_002 
writes table sybsystemprocs..sp_jdbc_getlob_rset_005 
writes table sybsystemprocs..sp_jdbc_getlob_rset_006 
writes table sybsystemprocs..sp_jdbc_getlob_rset_004 
writes table sybsystemprocs..sp_jdbc_getlob_rset_003 
writes table sybsystemprocs..sp_jdbc_getlob_rset_001