IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need a SELECT query


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
padma_prakasam

New User


Joined: 06 Oct 2005
Posts: 31

PostPosted: Wed Apr 18, 2007 12:50 pm
Reply with quote

Hi,

I have a scenario like this - I have a table and need to select a particular row from it (passing a cloumn value in WHERE clause) if found else i need to select all the rows having blank value for that column .
But not both at a time. Can this be possible in a single query?

Thanks,
Padma
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Apr 18, 2007 2:01 pm
Reply with quote

padma_prakasam wrote:
But not both at a time. Can this be possible in a single query?
No, either a single query with all the data or two querys so that "not both at a time".
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
No new posts SELECT from data change table DB2 5
Search our Forums:

Back to Top