I have been tasked to turn off CICS Screens.
Can anyone assist me with this.
Thanks
PlayHard
Last Activity: Mar 14 '08, 07:53 PM
Joined: Aug 21 '07
Location:
-
That is really cool! Awesome.
My only concern is when I run the report on January 6, 2008 and go back 7 days, is the system smart enough to know I want December 30 to 31st and January 1st to 5th. ?
Have a great Thanksgiving!... -
Wow!! It works.
Please explain how it works.
For current date I am using Nov 20. So if I use the formula you gave I get
Year(20-7)*1000=13000
Month(20-7)*100=1300
Day(20-7)*1=13
13000+1300+13=1 4313 (How does 14313 equal Nov 13 ?
Thanks again. Your a life Saver!...Leave a comment:
-
Date issue on interger field
I currently have a interger field with this format (YYYYMMDD) Example 20071118
I want to automate a weekly report Sun - Sat, therefore do not want to hard code the date. I want to say (Current Date - 7 days).
I have tried multiple things but they do not work.
Please help!
Thank YOU -
Thanks, I will look into that more...Leave a comment:
-
I understand that the two conditions contradict each other. My goal is to get the output so it looks like this.
Therefore output will have three columns
C_INCIDENT_TYPE | COUNT (From first Query | COUNT (from Second Query |
| | |
Would I use a join to run the query? Just asking?
...Leave a comment:
-
Combine queries for single output
I want my output in two columns like this:
C_INCIDENT_TYPE \ TOTAL COUNT
How do I combine my two queries to get result.
First Query
SELECT C_INCIDENT_TYPE , COUNT (*)
FROM TABLE_AUDIT
WHERE SUBSTR(I_USER,7 ,2) IN ('AD','WF','F5' )
AND SUBSTR(I_IMAGE_ COPY,12,8) > '00000000'
AND SUBSTR(I_IMAGE_ COPY,12,8) < '99999999'
AND D_H_STAMP BETWEEN...
No activity results to display
Leave a comment: