Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / November 2005

Tip: Looking for answers? Try searching our database.

Problem while copying BLOB from one table to another.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Basic - 23 Nov 2005 08:10 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.