View previous topic :: View next topic
|
Author |
Message |
Vignesh Sid
New User
Joined: 04 Sep 2017 Posts: 43 Location: India
|
|
|
|
I am working on a DB2 module where I should select a row from 5 tables (I can use fetch first row only in query). This selection is done to ensure that all 5 tables are available and we will send a mail that database is ready.
Is there any ways other than giving five different cursors for the five tables and fetching seperately and handle errors if a table is not available?
Please let me know for your thoughts!
Thanks! |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
How about one query selecting one column from each table? |
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
Quote: |
This selection is done to ensure that all 5 tables are available |
Do you mean the table or if the rows are available in the table?
Are these 5 tables connected by any column? If they are, then use LEFT OUTER JOIN and find which table column values are null. If they are Null then that would mean the connecting row is Not present.
. |
|
Back to top |
|
|
|