If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Information Integrator and LOBs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-21-04, 08:00
antony_87 antony_87 is offline
Registered User
 
Join Date: Apr 2004
Posts: 1
Question Information Integrator and LOBs

I have such question/situation:

there is DB2 (8.1.5) server (called for example A) as data server
and there is DB2(8.1.5) server (B) with Information Integrator(8.1.5) as join server

Client connects to server B and work with database on A in fact.
database on server A contains data only, and some tables contains BLOB columns.

Client uses stored procedures that created on server B and there is such bug: stored procedure (that return resultset with BLOB) fails at second start, then succesfully run, and again fails and so on fails every second run

procedure contains only simple select from table with BLOB column

CREATE PROCEDURE MAILER.GetAttachmentByID ( Attachment_ID INTEGER )
SPECIFIC MAILER.GetAttachmentByID
DYNAMIC RESULT SETS 1
LANGUAGE SQL
P1: BEGIN
DECLARE result1 RESULT_SET_LOCATOR VARYING;

DECLARE cursorAttachments CURSOR WITH RETURN TO CALLER FOR
SELECT ATTACHMENTID, ATTACHMENTNAME,Replicated, ATTACHMENT FROM MAILER.ATTACHMENTS
WHERE ATTACHMENTID=Attachment_ID;

OPEN cursorAttachments;
END P1

error:
ERROR [560BD] [IBM][CLI Driver][DB2/NT] SQL1822N From data source "-423" unexpected error code "A". elements "func="block_fetch" msg=" SQL0423N ". SQLSTATE=560BD

but if Client execute simple select with BLOB columns - there is no error

Last edited by antony_87; 04-21-04 at 08:05.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On