Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2007
    Posts
    6

    Unanswered: Good website for DB2

    A good DB2 website which explains the DB2 concepts with examples and contains good FAQ stuff. Suitable for a beginner.
    http://db2examples.googlepages.com/

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it's not that good

    for example,
    SELECT Empid, Empname, Department, Specialization
    FROM Employee e LEFT OUTER JOIN Department d
    WHERE e.Empid = d.Empid ;
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    I have posted some info to author about joins and he/she repaired SQLs from where to on cause.
    Now looks better.
    Grofaty

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The problem was not the syntax. It looks like the wrong tables or columns are being joined.

    But wait -- looking at the tables used in the example (see below) one can see they are not the same as the DB2 sample tables, and they are not normalized and make no sense whatsoever.

    Employee table columms:
    Empid
    Empname
    Manager
    Salary
    Location

    Department table columns:
    Empid
    Department
    Departmenthead
    Specialization

    Whomever put up that website is a moron (I do not use that term lightly), and has no understanding of database design or database administration.

    Please ignore that webiste, not to mention the fact that is created soley for commercial purposes and is direct competition with this forum.
    Last edited by Marcus_A; 10-27-07 at 19:51.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Joseph_T
    A good DB2 website which explains the DB2 concepts with examples and contains good FAQ stuff. Suitable for a beginner.
    I think what you meant to say is that the website was created by a beginner who has no idea what they are talking about.

    Why would someone visit a website created by a beginner to get information?

    You also forgot to mention that the website was created for the sole purpose of making money, probably by someone has no absolutely no knowledge of DB2 or database adminstration.
    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
    i think you're right, marcus

    more evidence, from the FAQ --

    Q26) Explain an outer join?
    A26) An outer join includes rows from tables when there are no matching values in the tables.

    Q27) What is a subselect? Is it different from a nested select?
    A27) A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criteria for the outer select.

    Q28) What is the difference between group by and order by?
    A28) Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.


    totally incomprehensible, i would have to conclude
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I didn't even read the FAQ. Apparently, this was a good decision. ;-)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  8. #8
    Join Date
    Oct 2007
    Posts
    6
    I am in the learning stage. And sorry for referring the above website

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Joseph_T
    I am in the learning stage.
    don't worry, we all were at one point

    Quote Originally Posted by Joseph_T
    And sorry for referring the above website
    the only reason you should be sorry is if you wrote that site

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

  10. #10
    Join Date
    Oct 2007
    Posts
    6
    Fortunately i didn't

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    here are my rules of thumb for whether a site is reliable

    1. if ads are prominent, they don't care about you, they are just doing it for the ad revenue

    2. if there is no "about" data that shows an actual person's name, they have something to hide (usually incompetence)

    3. if there are no links to other sites, they are not really trying to be a resource
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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