Problem while copying BLOB from one table to another.

[Basic]

Hi geeks,

I have to transfer some blobs objects from one table to another
depending on certain condition. I am using a Stored procedure for
this.
The snippet of the stored procedure which does this is as below

UPDATE F_PITBINARY SET BINARYDATA =
LOCOPY(BINARYDATA,'DPPITBINARYDATA','BINARYDATA')
WHERE ID = v_id and FPIT.ID = v_fpit_id
AND (FPIT.codetype,FPIT.code,FPIT.subrange) IN
(
SELECT impdppit.codetyp,impdppit.acode,impdppit.baureihe_ code
FROM IMP_DPPIT impdppit
WHERE impdppit.gguid = v_dppbd.dppit_id
AND impdppit.lastimport = c_curr_import
);
But i am getting the following error when i try to build the stored
proc.
[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named
"LOCOPY" of type "FUNCTION" having compatible arguments was found.

Any pointers would be appreciated.

Basic

[Knut Stolze]

Basic wrote:

Hi geeks,

I have to transfer some blobs objects from one table to another
depending on certain condition. I am using a Stored procedure for
this.
The snippet of the stored procedure which does this is as below

UPDATE F_PITBINARY SET BINARYDATA =
LOCOPY(BINARYDATA,'DPPITBINARYDATA','BINARYDATA')
WHERE ID = v_id and FPIT.ID = v_fpit_id
AND (FPIT.codetype,FPIT.code,FPIT.subrange) IN
(
SELECT impdppit.codetyp,impdppit.acode,impdppit.baureihe_ code
FROM IMP_DPPIT impdppit
WHERE impdppit.gguid = v_dppbd.dppit_id
AND impdppit.lastimport = c_curr_import
);
But i am getting the following error when i try to build the stored
proc.
[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named
"LOCOPY" of type "FUNCTION" having compatible arguments was found.

What kind of function is this LOBCOPY and how exactly is it supposed to
work? It is not a built-in function in DB2 UDB.

If you just want to copy a LOB value, treat it like any other value:

UPDATE tab2
SET lobColumn2 = ( SELECT lobColumn1
FROM tab1
WHERE ... )
WHERE ...

--
Knut Stolze
DB2 Information Integration Development
IBM Germany