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

it's not that good

for example,

Hi,
I have posted some info to author about joins and he/she repaired SQLs from where to on cause.
Now looks better.
Grofaty

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.

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.

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

I didn't even read the FAQ. Apparently, this was a good decision. ;-)

I am in the learning stage. And sorry for referring the above website

don't worry, we all were at one point

the only reason you should be sorry is if you wrote that site

Fortunately i didn't

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