473,385 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How to insert picture into BLOB in DB2 using command editor?

Hello I am using IBM DB2 express C..

I need to store pictures(*.jpg,*.gif,etc..) in the database.
I got to know it can be done by using BLOB but I am not getting how we can do it exactly..
Please Help me


If my table is like this.
Expand|Select|Wrap|Line Numbers
  1.  create table sample
  2.  (pic_number int,
  3.  picture blob(102400));
  4.  

How can i insert a image which is for example in "C:\mypicture.jpg"


It is helpful if your answer is by using DB2 "command line editor"




Any sort of help is greatly appreciated..
Thanking you in advance..
Feb 8 '11 #1
0 2046

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: JV | last post by:
In the SQL Command editor (click on a data adapter, in property window find the SELECT command property, drill down to the CommandText sub-property and click the button to edit) if you use a UNION...
7
by: Aj-India | last post by:
Is there anyway that I could preserve the comments when creating an SP from Command Editor,so that when i import the SP in the development center I can see them. The reason for such a request is...
2
by: apattin | last post by:
Hi all, We are using V8.1.9 (aka 8.2) and we are having an annoying issue with the Command Editor. It does not seem to remember, from session to session, the "targets" that should appear in the...
3
by: Mark A | last post by:
In the DB2 Admin Client (8.2.4), when the results of a query are displayed in the grid that looks like a spreadsheet (using Command Editor or double click on table name in Control Center). The data...
8
by: Ivan | last post by:
Hi I am new in DB2, and I have some problems when I try run stored procedures, and others statements. I made one stored procedure very simple, but this show different messages. I have followed...
0
by: Kevin Edwards | last post by:
Hi, all Running a query via Command Editor from a DB2UDB V8 Windows2000 client, if I cancel the executing query the query seems to just carry on anyway (unlike Command Center which used to...
0
by: cooldlkk | last post by:
Hi , could someone pls advise the command for to insert picture to excel using vb command. Dim img as image how to mention location of file name , path directory . what if the file name and...
0
by: avisekrishi | last post by:
Hi , I have 100 image . I need to follow the following steps 1. Open a word document 2. Click on Insert -> Picture -> File and then open the image file 3. The Image gets opened in Word.
2
by: db2learner | last post by:
Hi, I am new to DB2 and i just started worked on it a couple of days back. I have created basic EMPLOYEE table from control centre which has 2 fields: EmpNo, EmpName. I am trying to write...
3
by: JFKJr | last post by:
Hello everyone, I am trying to insert a picture in an excel spreadsheet cell using Access VBA. The following excel VBA code is working perfectly fine and I am able to insert picture in "A1" cell....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.