Page 1 of 1
JOINs in DB2, need help.
Posted: Mon Sep 14, 2015 1:58 pm
by Manju Mainframe
Hi,
The concepts of joins are very confusing for me. I really do not undertand the difference between Inner Join and Outer Joins. I have been looking for some good example on inner join, left outer join, and right outer join but could not find something for mainframes.
Could someone provide me examples of the same? And if possible explain it.
Re: JOINs in DB2, need help.
Posted: Mon Sep 14, 2015 3:32 pm
by nicc
It is out there on the internet because I have seen it in one of the many tutorials but which one I cannot remember. I think you need one with a Venn diagram to explain it better.
Re: JOINs in DB2, need help.
Posted: Wed Sep 16, 2015 8:52 pm
by zprogrammer
Check the below diagram , I have tried to explain join in very quick way hope this is clear
JOINS.jpg
Re: JOINs in DB2, need help.
Posted: Mon Mar 28, 2016 11:14 am
by Manju Mainframe
Pandora-Box wrote:Check the below diagram , I have tried to explain join in very quick way hope this is clear
JOINS.jpg
Thanks a lot for the diagram Pandora-Box.
Re: JOINs in DB2, need help.
Posted: Mon Mar 28, 2016 12:21 pm
by Chandan Yadav
Try out some examples execution in Spufi or QMF you will get better understanding
Re: JOINs in DB2, need help.
Posted: Tue Apr 05, 2016 2:11 pm
by Manju Mainframe
Thanks Chandan. But I am not allowed to create some test data to test these things. With out test tables how can I do it?
Re: JOINs in DB2, need help.
Posted: Tue Apr 05, 2016 3:19 pm
by enrico-sorichetti
if You are a developer of You should have access to a DB2 instance
think about the tables You have access and if they share some columns You can try the joins on them
and remember to limit the result setÂ
Re: JOINs in DB2, need help.
Posted: Wed Apr 06, 2016 11:00 am
by Chandan Yadav
You can have Db2 instance on local machine check for Db2 Express edition n test it out. Joins works same if you doing it on local machine or on mainframes.
As Enrico said if you are a developer you should have access
Re: JOINs in DB2, need help.
Posted: Fri May 06, 2016 12:16 pm
by Manju Mainframe
I'm in to support project for some time where SPUFI and QMF use is restricted.
Re: JOINs in DB2, need help.
Posted: Fri May 06, 2016 6:51 pm
by Robert Sample
I'm in to support project for some time where SPUFI and QMF use is restricted.
Why not download and install the free DB2 system for Windows onto your personal machine?
Re: JOINs in DB2, need help.
Posted: Sun May 08, 2016 9:18 pm
by nicc
Or even download any old RDBMS that uses SQL and experiment with that. For the record I use SQLite and it gets me through all I need to know with standard SQL queries.
Re: JOINs in DB2, need help.
Posted: Fri May 13, 2016 2:27 pm
by Manju Mainframe
Why not download and install the free DB2 system for Windows onto your personal machine?
Or even download any old RDBMS that uses SQL and experiment with that. For the record I use SQLite and it gets me through all I need to know with standard SQL queries.
Thanks for the suggestion I did not think about these. Will try them. Thanks !