Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2007
    Posts
    4

    Unanswered: A noobs guide to DB2 please

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    DB2 is a relational database

    SQL is the only language it uses

    DB2 can store images just like other databases can
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Posts
    4
    Thanks r397

    Does it store images as blobs?

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

    Thanks

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, BLOB

    see CREATE TABLE
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by kurose
    Does DB2 work with other languages like SQL?
    Yes, IBM invented SQL (structured query language).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by r937
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by r937
    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."
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Jan 2003
    Posts
    1,605
    Quote Originally Posted by kurose
    Thanks r397

    Does it store images as blobs?

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

    Thanks
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •