Hi,

First of all nice forum.

I have used php and mysql before to create content management systems etc but i have never used DB2 before and i am a little confused as to what it exactly is.

I was wondering if someone could give me a kind of noobs guide to it.

Does DB2 work with other languages like SQL?

How does it handle images?

Thanks for your time.

kurose

DB2 is a relational database

SQL is the only language it uses

DB2 can store images just like other databases can

Thanks r397

Does it store images as blobs?

Do you have any links at all that can explain how it handles images?

Thanks

yes, BLOB

see CREATE TABLE

Yes, IBM invented SQL (structured query language).

not entirely true, marcus (oracle was first to market), but IBM certainly kick-started it with Codd's paper

see http://en.wikipedia.org/wiki/Sql#History

by the way, i started using SQL with DB2 and QMF in 1987, so this is my twentieth year of SQL experience!!

I didn't say that IBM was first to market. IBM presented SQL at a conference and Oracle copied it. IBM invented it.

BTW, not everything in Wikipedia is accurate since anyone can update those articles, and I believe there were others who went to market before Oracle with a relational database. Oracle was orignally called a different product that did not use SQL.

okay, point taken, IBM invented it

but instead of slagging wikipedia, how about going in to an article about which you have substantial knowledge (hint: that one), and doing a quick check to make sure it's accurate, and updating it if it isn't

thank you

After reading the article, I would say it is fairly accurate. Here is what it says:

"During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon, but not strictly faithful to, Codd's model. Structured English Query (SQL) Language ("SEQUEL") was designed to manipulate and retrieve data stored in System R. The acronym SEQUEL was later condensed to SQL because the word 'SEQUEL' was held as a trademark by the Hawker Siddeley aircraft company of the UK. Although SQL was influenced by Codd's work, Donald D. Chamberlin and Raymond F. Boyce at IBM were the authors of the SEQUEL language design.[1] Their concepts were published to increase interest in SQL."

Hi,
I haven't tried this out, but if I remember correctly college made this happen by using UDF (reads the binary data from file) and then db2 insert command (used UDF to insert image into db2)
Hope this helps,
Grofaty