|
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: 2454
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 |
|
|
|
|
