Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Selecting a row from multiple tables!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Vignesh Sid

New User


Joined: 04 Sep 2017
Posts: 43
Location: India

PostPosted: Thu Oct 26, 2017 6:09 pm    Post subject: Selecting a row from multiple tables!
Reply with quote

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
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2253
Location: Hampshire, UK

PostPosted: Thu Oct 26, 2017 7:54 pm    Post subject:
Reply with quote

How about one query selecting one column from each table?
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 447
Location: USA

PostPosted: Thu Oct 26, 2017 7:59 pm    Post subject: Reply to: Selecting a row from multiple tables!
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is multiple program names allowed in ... Sakthidevi PL/I & Assembler 1 Tue Nov 19, 2019 11:12 pm
No new posts Count From Multiple Inputs Tyler Dunbar DFSORT/ICETOOL 5 Tue Nov 12, 2019 1:07 am
No new posts ADRDSSU BY(REFDT... not selecting cor... Greg Roschel IBM Tools 2 Wed Sep 18, 2019 7:23 pm
No new posts Is possible to concatenate multiple P... Poha Eater DFSORT/ICETOOL 6 Fri Aug 02, 2019 1:21 pm
No new posts Split input file into multiple files ... srini24 DFSORT/ICETOOL 1 Sat Mar 30, 2019 9:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us