|
View previous topic :: View next topic
|
| Author |
Message |
Kkr6799
New User
Joined: 02 Aug 2023
Posts: 1
Location: India
|
|
|
|
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 |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| 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 |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006
Posts: 2547
Location: Silicon Valley
|
|
|
|
re: "data from table(ABC)"
Show us the columns that are in table ABC. And maybe a description of the columns. |
|
| Back to top |
|
|
|
|
