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

1     /** SECTION END: CLEANUP **/
2     
3     create 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

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