Ok, I think I just may be a moron, but where the heck are the Image
extenders found? I've look all around, tried all the DB2 cd's I have,
are they installed by default somewhere? Which install fileset (AIX) are
they part of?
The CD's only show spatial and xml extenders? 8 2202
yoyo wrote: Ok, I think I just may be a moron, but where the heck are the Image extenders found? I've look all around, tried all the DB2 cd's I have, are they installed by default somewhere? Which install fileset (AIX) are they part of? The CD's only show spatial and xml extenders?
The AIV webpages state that it is bundled with several editions of DB2. You
happen to have one of those? http://www-306.ibm.com/software/data...rodbundle.html
Related, but different question: what do you have in mind with this
extender?
You have to remember that it is based on 8-10 year old technology and maybe
this is a better alternative? http://tinyurl.com/q4zpn
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
yoyo wrote: Ok, I think I just may be a moron, but where the heck are the Image extenders found? I've look all around, tried all the DB2 cd's I have, are they installed by default somewhere? Which install fileset (AIX) are they part of? The CD's only show spatial and xml extenders?
If I'm not mistaken, you have to purchase one of the Developer's
Editions to get the Image Extender (if it still even exists).
Larry Edelstein
Knut Stolze wrote: yoyo wrote:
Ok, I think I just may be a moron, but where the heck are the Image extenders found? I've look all around, tried all the DB2 cd's I have, are they installed by default somewhere? Which install fileset (AIX) are they part of? The CD's only show spatial and xml extenders?
The AIV webpages state that it is bundled with several editions of DB2. You happen to have one of those? http://www-306.ibm.com/software/data...rodbundle.html
Related, but different question: what do you have in mind with this extender? You have to remember that it is based on 8-10 year old technology and maybe this is a better alternative? http://tinyurl.com/q4zpn
I see that page, I look at my media, and it's not there.
I have every DB2 8.1 & 8.2 edition out there (enterprise is what I have
actually installed). It's not called out on any filesets on any of the
install media.
I've come across that page many times now, nice stuff, but unless I
missed something (and that's possible) it deals with blobs already
existing in the database, which I have yet to accomplish. It doesn't say
anything about how to insert those blobs.
What do I have in mind? Well, since you ask....I want to store an image
from a file into a blob from with php code using odbc. There's known
issues with php&db2 trying to insert and retrieve blob (they both point
the blame on the other and the issue is still open, from 2002). So next
I wanted just to try shell_exec a command line insert to insert a blob
from a file.
It doesn't even have to be a blob, I try to use clob and convert my
image before insert....blah. .blah...many tries, mostly ending up with
only 4k of the image coming back out.
I just need to store small thumbnail images in the database. I'm going
crazy here. 2 day on this. 2 DAYS!!!!!!
Is there a better way? I've searched for the last 2 days on this, and
nothing. Everything points to the DB2 image extenders, which I havn't
tried yet.
yoyo wrote: What do I have in mind? Well, since you ask....I want to store an image from a file into a blob from with php code using odbc. There's known issues with php&db2 trying to insert and retrieve blob (they both point the blame on the other and the issue is still open, from 2002).
You are probably referring to the old odbc-php driver that was used to talk
to DB2. This was not quite acceptable code. For example, there was no
support for LOBs at all. (It is definitively a PHP issue.) You should
rather stick with the newer Zend Core for IBM that handles stuff properly: http://www-306.ibm.com/software/data/info/zendcore/
So next I wanted just to try shell_exec a command line insert to insert a blob from a file. It doesn't even have to be a blob, I try to use clob and convert my image before insert....blah. .blah...many tries, mostly ending up with only 4k of the image coming back out.
Those 4K might be the result from the truncation done by the DB2 CLP. The
whole LOB might actually be stored in the row.
Is there a better way? I've searched for the last 2 days on this, and nothing. Everything points to the DB2 image extenders, which I havn't tried yet.
Unless you need some sort of image processing, the extender won't help you
either.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Knut Stolze wrote: yoyo wrote:
What do I have in mind? Well, since you ask....I want to store an image from a file into a blob from with php code using odbc. There's known issues with php&db2 trying to insert and retrieve blob (they both point the blame on the other and the issue is still open, from 2002).
You are probably referring to the old odbc-php driver that was used to talk to DB2. This was not quite acceptable code. For example, there was no support for LOBs at all. (It is definitively a PHP issue.) You should rather stick with the newer Zend Core for IBM that handles stuff properly: http://www-306.ibm.com/software/data/info/zendcore/
So next I wanted just to try shell_exec a command line insert to insert a blob from a file. It doesn't even have to be a blob, I try to use clob and convert my image before insert....blah. .blah...many tries, mostly ending up with only 4k of the image coming back out.
Those 4K might be the result from the truncation done by the DB2 CLP. The whole LOB might actually be stored in the row.
Is there a better way? I've searched for the last 2 days on this, and nothing. Everything points to the DB2 image extenders, which I havn't tried yet.
Unless you need some sort of image processing, the extender won't help you either.
Zend core. There's something I've not come across. I really wonder if it
will help me though, to store that image in a DB2 database.
The UDF I wanted from the image extender is the DB2IMAGE one, which
allows someone to do this from a command line:
insert into mytablewithblob colum (CHARATT1,BLOBA TT2) values
('ken',DB2IMAGE ('/tmp/myjpg.jpg','jpg ','26k'))
and it's supposed to take that jpeg and put it in your blob column.
If I have a true blob in there, I'm able to get it out with php odbc.
(I had to use the db2 import function to populate something in that
database with a blob though, I really don't want to use that as a
solution however)
I've never had a problem with odbc connector for db2 in php (until now),
been using for 3 years. I didn't even know of the zend core that IBM wrote.
I'll check out the code and see what's there. Is there native support
for blob then???? Hopefully....
Anyway, thatnks for the help, it's hope anyway,
ANy idea where those DB2 IMage extensions are in 8.1 or 2???????
Ken
yoyo wrote: Knut Stolze wrote:
yoyo wrote:
What do I have in mind? Well, since you ask....I want to store an image from a file into a blob from with php code using odbc. There's known issues with php&db2 trying to insert and retrieve blob (they both point the blame on the other and the issue is still open, from 2002). You are probably referring to the old odbc-php driver that was used to talk to DB2. This was not quite acceptable code. For example, there was no support for LOBs at all. (It is definitively a PHP issue.) You should rather stick with the newer Zend Core for IBM that handles stuff properly: http://www-306.ibm.com/software/data/info/zendcore/
So next I wanted just to try shell_exec a command line insert to insert a blob from a file. It doesn't even have to be a blob, I try to use clob and convert my image before insert....blah. .blah...many tries, mostly ending up with only 4k of the image coming back out. Those 4K might be the result from the truncation done by the DB2 CLP. The whole LOB might actually be stored in the row.
Is there a better way? I've searched for the last 2 days on this, and nothing. Everything points to the DB2 image extenders, which I havn't tried yet. Unless you need some sort of image processing, the extender won't help you either.
Zend core. There's something I've not come across. I really wonder if it will help me though, to store that image in a DB2 database. The UDF I wanted from the image extender is the DB2IMAGE one, which allows someone to do this from a command line:
insert into mytablewithblob colum (CHARATT1,BLOBA TT2) values ('ken',DB2IMAGE ('/tmp/myjpg.jpg','jpg ','26k'))
and it's supposed to take that jpeg and put it in your blob column.
If I have a true blob in there, I'm able to get it out with php odbc. (I had to use the db2 import function to populate something in that database with a blob though, I really don't want to use that as a solution however) I've never had a problem with odbc connector for db2 in php (until now), been using for 3 years. I didn't even know of the zend core that IBM wrote. I'll check out the code and see what's there. Is there native support for blob then???? Hopefully....
Anyway, thatnks for the help, it's hope anyway,
ANy idea where those DB2 IMage extensions are in 8.1 or 2???????
Ken
Watch out for an article on BLOB in PHPs by Helmut Tessarek in the next
issue of php|architect magazine.
Cheers
Sege
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
yoyo wrote: Zend core. There's something I've not come across. I really wonder if it will help me though, to store that image in a DB2 database. The UDF I wanted from the image extender is the DB2IMAGE one, which allows someone to do this from a command line:
insert into mytablewithblob colum (CHARATT1,BLOBA TT2) values ('ken',DB2IMAGE ('/tmp/myjpg.jpg','jpg ','26k'))
and it's supposed to take that jpeg and put it in your blob column.
To be more precise, it takes an image that resides in a file in the file
system and stores it in the BLOB column. But that BLOB column exists in a
so-called side table and not your normal user table. Only a
reference/handle is stored in the user table.
If you want to go that route, I recommend that you have a look at the
article I cited as the Download includes a UDF "SI_loadIma ge" that does
exactly what you want with much less overhead. (You can also implement
something like this in Java if you like.)
If I have a true blob in there, I'm able to get it out with php odbc. (I had to use the db2 import function to populate something in that database with a blob though, I really don't want to use that as a solution however)
You don't have to go over the file route. You can directly insert a BLOB
send from the client into the database. Here is a sample PHP script that
does just that: http://tinyurl.com/r3oqg
Note that the script is still based on the old PHP ODBC driver, but that
driver was heavily modified.
And here is a script to extract BLOBs and send them (as PDF) to the client: http://tinyurl.com/odcwf
I've never had a problem with odbc connector for db2 in php (until now), been using for 3 years. I didn't even know of the zend core that IBM wrote. I'll check out the code and see what's there. Is there native support for blob then???? Hopefully....
Yes, BLOB support is there (besides that a lot of other bugs don't exist
there).
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Knut Stolze wrote: yoyo wrote:
Zend core. There's something I've not come across. I really wonder if it will help me though, to store that image in a DB2 database. The UDF I wanted from the image extender is the DB2IMAGE one, which allows someone to do this from a command line:
insert into mytablewithblob colum (CHARATT1,BLOBA TT2) values ('ken',DB2IMA GE('/tmp/myjpg.jpg','jpg ','26k'))
and it's supposed to take that jpeg and put it in your blob column.
To be more precise, it takes an image that resides in a file in the file system and stores it in the BLOB column. But that BLOB column exists in a so-called side table and not your normal user table. Only a reference/handle is stored in the user table.
If you want to go that route, I recommend that you have a look at the article I cited as the Download includes a UDF "SI_loadIma ge" that does exactly what you want with much less overhead. (You can also implement something like this in Java if you like.)
If I have a true blob in there, I'm able to get it out with php odbc. (I had to use the db2 import function to populate something in that database with a blob though, I really don't want to use that as a solution however)
You don't have to go over the file route. You can directly insert a BLOB send from the client into the database. Here is a sample PHP script that does just that:
http://tinyurl.com/r3oqg
Note that the script is still based on the old PHP ODBC driver, but that driver was heavily modified.
And here is a script to extract BLOBs and send them (as PDF) to the client: http://tinyurl.com/odcwf
I've never had a problem with odbc connector for db2 in php (until now), been using for 3 years. I didn't even know of the zend core that IBM wrote. I'll check out the code and see what's there. Is there native support for blob then???? Hopefully....
Yes, BLOB support is there (besides that a lot of other bugs don't exist there).
Hey, thanks alot for those. That really helps! I've been playing with
the driver too, mabey I can get it to work.. I've checked out the Zend
core for IBM as well, looks nice, but in order for me to use I need to
change alot of things etc....I'll try it on my next project. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ken North |
last post by:
Updated driver, provider and extender lists are now available at SQLSummit.com.
The newest list is XQuery processors.
XQuery engines (29)
www.SQLSummit.com/XQueryProc.htm
ODBC drivers (212)
www.SQLSummit.com/odbcvend.htm
JDBC drivers (112)
|
by: Ken North |
last post by:
Updated driver, provider and extender lists are now available at SQLSummit.com.
The newest list is XQuery processors.
XQuery engines (29)
www.SQLSummit.com/XQueryProc.htm
ODBC drivers (212)
www.SQLSummit.com/odbcvend.htm
JDBC drivers (112)
|
by: wayne mcfadden |
last post by:
Hi,
I'm stumped. Our text extenders stopped working on one database. I
think that i'm missing something simple here.
The column is enabled...
but when you do an index status
it doesn't know anything about it.
Any thoughts?
Thanks
|
by: Rolf Schuster |
last post by:
On Windows XP SP2, I am trying to create and enable a table for use by
an AIV extender.
In the extender command line processor (db2ext), I do
db2ext => enable database for db2image
without a problem. However, when I do
db2ext => enable table <mytable> for db2image
|
by: Vavel |
last post by:
Hi!
I'm looking for DB2 UDB Text Extender and DB2 UDB Audio Image and Video
Extenders,but I can't download it from
http://www-306.ibm.com/software/data/db2/extenders/support.html
(error, document not found). Does anybody could help me?
Thank you
Grzesiek
| |
by: Allan Ebdrup |
last post by:
Hi
I'm thinking up a way to implement multilanguage controls in ASP.Net 2.0,
My multilanguage texts lie in a database or resource files, they are
accessed through a webservice where I specify a number of text ids and a
language and get the corresponding texts back.
I would like to implement an extender where I specify the multilanguage text
id in the extender for all controls on a page. So for all multilanguage
controls (for example...
|
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 to enable that
Db2 Image Extender & the following steps to insert images into the
database.
Please Help me out...........
|
by: sheenaa |
last post by:
I want to use AJAX features in my ASP.NET with C# website application 2005.
For that i have already installed the following onto my pc.
ASP.NET 2.0 AJAX Extensions 1.0
ASP.NET AJAX Futures January CTP
ASP.NET AJAX Control Toolkit.
In the toolbox on left-side i get the following tab control
AJAX Extensions.
|
by: Garima12 |
last post by:
I have 3 collapsible panel extenders containing other controls on my web page. Initially, I am loading one on page load. I want to collapse other 2 panels on click of any one out of those three as well as want to make the textboxes blank contained by them. Can you suggest me how will it work?
thks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |