Hi geeks
I have to transfer some blobs objects from one table to anothe
depending on certain condition. I am using a Stored procedure fo
this
The snippet of the stored procedure which does this is as belo
UPDATE F_PITBINARY SET BINARYDATA
LOCOPY(BINARYDATA,'DPPITBINARYDATA','BINARYDATA'
WHERE ID = v_id and FPIT.ID = v_fpit_i
AND (FPIT.codetype,FPIT.code,FPIT.subrange) I
SELECT impdppit.codetyp,impdppit.acode,impdppit.baureihe_cod
FROM IMP_DPPIT impdppi
WHERE impdppit.gguid = v_dppbd.dppit_i
AND impdppit.lastimport = c_curr_impor
);
But i am getting the following error when i try to build the store
proc
[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine name
"LOCOPY" of type "FUNCTION" having compatible arguments was found
Any pointers would be appreciated
Basi
Knut Stolze - 23 Nov 2005 14:40 GMT
> Hi geeks,
>
[quoted text clipped - 19 lines]
> [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 ...

Signature
Knut Stolze
DB2 Information Integration Development
IBM Germany