hi
i've encountered a problem with db2image extender for db2 version 8.2
i inserted a record into table allegato_immagine:
insert into allegato_immagine values( '1',
mmdbsys.db2image(current server, 'c:\1.jpg','JPG',1,'immagine 1')
,current timestamp
,current timestamp
);
this execute is ok
when i try to use any UDF of DB2IMAGE i always have the same problem
example using UDF MMDBSYS.COMMENT
---
SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico
"COMMENTDB2IMAGE") ha
restituito un errore SQLSTATE con testo diagnostico "sqlcode=-204
clistate=S0002. ". SQLSTATE=38624
SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico
"COMMENTDB2IMAGE") ha restituito un errore SQLSTATE con testo
diagnostico "sqlcode=-204 clistate=S0002.
".
--- 3 1880
ilmagowalter wrote: hi i've encountered a problem with db2image extender for db2 version 8.2
i inserted a record into table allegato_immagine:
insert into allegato_immagine values( '1', mmdbsys.db2image(current server, 'c:\1.jpg','JPG',1,'immagine 1') ,current timestamp ,current timestamp );
this execute is ok
when i try to use any UDF of DB2IMAGE i always have the same problem
example using UDF MMDBSYS.COMMENT --- SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico "COMMENTDB2IMAGE") ha restituito un errore SQLSTATE con testo diagnostico "sqlcode=-204 clistate=S0002. ". SQLSTATE=38624
SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico "COMMENTDB2IMAGE") ha restituito un errore SQLSTATE con testo diagnostico "sqlcode=-204 clistate=S0002. ".
This message says that the logic inside the Image Extender could not find a
table (or some other object) that it needs. Hence, the SQLCODE=-204
information. Taking a CLI Trace might help to narrow down the issue.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
but the table and the column exist!
and i stored image with the insert
what can i do?
Knut Stolze <st****@de.ibm.com> wrote in message news:<cu**********@fsuj29.rz.uni-jena.de>... ilmagowalter wrote:
hi i've encountered a problem with db2image extender for db2 version 8.2
i inserted a record into table allegato_immagine:
insert into allegato_immagine values( '1', mmdbsys.db2image(current server, 'c:\1.jpg','JPG',1,'immagine 1') ,current timestamp ,current timestamp );
this execute is ok
when i try to use any UDF of DB2IMAGE i always have the same problem
example using UDF MMDBSYS.COMMENT --- SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico "COMMENTDB2IMAGE") ha restituito un errore SQLSTATE con testo diagnostico "sqlcode=-204 clistate=S0002. ". SQLSTATE=38624
SQL0443N La routine "MMDBSYS.COMMENT" (nome specifico "COMMENTDB2IMAGE") ha restituito un errore SQLSTATE con testo diagnostico "sqlcode=-204 clistate=S0002. ".
This message says that the logic inside the Image Extender could not find a table (or some other object) that it needs. Hence, the SQLCODE=-204 information. Taking a CLI Trace might help to narrow down the issue.
ilmagowalter wrote: but the table and the column exist! and i stored image with the insert what can i do?
As I said, a CLI trace might be very helpful.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Darren Guy |
last post by:
Hello All
I am trying to use the extender control from
http://dotnetrix.co.uk/menus.html so that I can add a tag to MenuItem
But I cant get it to work.
This is the steps that I took
...
|
by: Greg |
last post by:
Just wanted to post this solution because I could not find it anywhere
on Google Groups. This solution applies to Windows only. Here's the
scenario - you have done the following:
- installed DB2...
|
by: Stanley Sinclair |
last post by:
Bear with me. I am being very calm; took a Valium. I have waited two
weeks to write this, because every time I wrote it before the message
was, at best, nasty.
I need to use the services of...
|
by: ilmagowalter |
last post by:
hi
i've encountered a problem with db2image extender for db2 version 8.2
i inserted a record into table allegato_immagine:
insert into allegato_immagine values( '1',
mmdbsys.db2image(current...
|
by: Nina via DBMonster.com |
last post by:
Hi,
I am trying to enable a database for use with aiv extender.The problem is
that when i try to execute:
enable database for db2image i get the following error:
db2ext => enable database for...
|
by: Lan W via DBMonster.com |
last post by:
Hi,
I try to install Db2 Net Search Extender on my Db2 workgroup server edition
on windows machine. When I verify the installation from command window as
typed >nsesampla.bat sample, I received...
|
by: Brad |
last post by:
To DB2 Personal Developer Edition GIS users:
How do I acquire a spatial extender license key for the DB2 PDE? I
expected to be able to use it right out of the box.
Brad
|
by: satish mullapudi |
last post by:
Hi Gurus,
I am using DB2 UDB 8.2.I want to load/insert images into DB2
database.So I found out we need to enable DB2 Image extender .How to
enable that extender? Please tell the complete process...
|
by: davehowey |
last post by:
'Learning Python' by Lutz and Ascher (excellent book by the way)
explains that a subclass can call its superclass constructor as
follows:
class Super:
def method(self):
# do stuff
class...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |