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

current date in db2 query in jcl
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
shell100

New User


Joined: 14 Apr 2006
Posts: 25
Location: Banglore,India
PostPosted: Mon May 08, 2006 1:43 pm
 Reply with quote
Hi,

As per my requirement i have to code db2 query in jcl.

Select A_ID
from table B
where A_DATE =! Current_date

How to get current date here.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 463
PostPosted: Mon May 08, 2006 1:54 pm
 Reply with quote
Hi,

Quote:
Hi,

As per my requirement i have to code db2 query in jcl.

Select A_ID
from table B
where A_DATE =! Current_date


Can not use date functions here?

Regards
Rupesh
Back to top
View user's profile Send private message
steve

New User


Joined: 24 Mar 2005
Posts: 16
Location: Long Island
PostPosted: Mon May 08, 2006 3:33 pm
 Reply with quote
the following shld work for u..

Select A_ID
from table B
where A_DATE <> CURRENT DATE
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 -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts Need to convert date format DFSORT/ICETOOL 20
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us