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

Fetch data from programs execute (date) to current date


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

New User


Joined: 02 Aug 2023
Posts: 1
Location: India

PostPosted: Wed Aug 02, 2023 3:43 pm
Reply with quote

Hi everyone

I need to fetch the data from table(ABC) based on job executed date and current date.
Can any please send me the query to fetch data .

Example:

Select name from ABC
---> fetch date from program exec date(previously) and today's date.

Please send me this query ASAP...

Thanks in advance
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2081
Location: USA

PostPosted: Wed Aug 02, 2023 5:08 pm
Reply with quote

36_8_9.gif 36_8_2.gif 36_8_15.gif 36_8_14.gif 36_8_13.gif

2020.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8698
Location: Dubuque, Iowa, USA

PostPosted: Wed Aug 02, 2023 9:06 pm
Reply with quote

Quote:
Please send me this query ASAP...
This is a help forum. It is not a write-the-code-for-you forum. And when you say you want something ASAP, you actually reduce the chances that you'll get any response at all. If you need something ASAP, convince your management to pay for a consultant to help you.

Furthermore, unless you -- or your site -- have specifically coded up something to retain the last execute date, this is not easily available to the system (as in, you need to read SMF records possibly going back months to capture it).
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2569
Location: Silicon Valley

PostPosted: Thu Aug 03, 2023 12:02 am
Reply with quote

re: "data from table(ABC)"

Show us the columns that are in table ABC. And maybe a description of the columns.
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 To fetch records that has Ttamp value... DFSORT/ICETOOL 5
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Store the data for fixed length COBOL Programming 1
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
Search our Forums:

Back to Top