Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
select null or max end date

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

New User


Joined: 15 Jun 2006
Posts: 13

PostPosted: Fri Jan 25, 2008 12:07 pm    Post subject: select null or max end date
Reply with quote

Hi,
I have a doubt in writing a query, the purpose of the query is it retrieve a date from a table.
In the table if there are rows with null. then i should get null
but if there is no null then i should get max of the date.

eg:
if table 01 has 4 rows and the values are as below then i should get NULL

date
2007-10-19
2007-09-08
null
2007-02-01

answer = null

if table 01 has 4 rows and the values are as below then i should get 2007-10-19

date
2007-10-19
2007-09-08
2007-02-03
2007-02-01

answer = 2007-10-19

can anyone help me in writing a shingle query for the same. we can do the same with a cursor, but I want to know if we can do it through a single query or not.
Back to top
View user's profile Send private message

rag swain

New User


Joined: 17 Dec 2007
Posts: 33
Location: pune,INDIA

PostPosted: Fri Jan 25, 2008 11:36 pm    Post subject: Reply to: select null or max end date
Reply with quote

you can write query like
Code:

select max(char(date_col))
   from table_name;


and use function NULLIF(CHAR(DATE_COL) with the query to find the result, though not yet tested. might some other day, quite late.
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 How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Date in where clause - Windows Karthikeyan Subbarayan DB2 9 Wed Nov 15, 2017 9:07 pm
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

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