Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Get correct date and time when current time is over 12 hrs
Goto page 1, 2  Next
 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Fri Oct 14, 2016 10:40 pm    Post subject: Get correct date and time when current time is over 12 hrs
Reply with quote

Hi ,
I have written a SQL query to create a date file which is used by job to fetch sales data for every past 1 hour . Problem is when current time is pass 12 hours y (i,e) by 12 AM it is fetching CURRENT DATE which is wrong , for that we are hardcoding date for the query input .

Code:

SELECT CAST(VARCHAR_FORMAT(GREGORIAN_DATE,'MM/DD/YYYY') AS CHAR(10)),
CAST('|' AS CHAR(1)),
CAST(VARCHAR_FORMAT(GREGORIAN_DATE,'YYYY.MM.DD') AS CHAR(10)),
SUBSTR(DIGITS(COL2),9,2),
CAST('|' AS CHAR(1)),
CASE WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 1 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 1 HOUR)
          THEN CAST ('CURRHOUR' AS CHAR(8))
     
     WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 2 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 2 HOUR)
          THEN CAST ('PREVHOUR' AS CHAR(8))

     WHEN GREGORIAN_DATE  = CURRENT_DATE AND
          COL2 >= HOUR(CURRENT_TIME) 
          THEN CAST('OPENHOUR' AS CHAR(8))

ELSE CAST('CLSDHOUR' AS CHAR(8))  END,
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 2 HOUR)),9,2)
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 1 HOUR)),9,2)
CAST('|' AS CHAR(1))

FROM TEST.CALENDER_TABLE ,
(SELECT  00 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  01 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
  SELECT  02 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  03 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  04 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  05 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  06 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  07 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  08 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  09 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  10 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  11 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  12 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  13 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  14 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  15 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  16 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  17 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  18 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  19 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  20 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  21 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  22 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  23 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL)  AS  A
WHERE GREGORIAN_DATE =  CURRENT_DATE <-  hardcoded everytime with current date on each day .
ORDER BY GREGORIAN_DATE,COL2
WITH UR;


Output file looks like
10/14/2016|2016.10.14|00|CLSDHOUR|09|10|
....
....,
WHEN IT RUNS at 12:30 in Night it represents as

10/15/2016|2016.10.15|23|CURRHOUR|22|23|

but expected is

10/14/2016|2016.10.14|23|CURRHOUR|22|23|

I should check for time by adding another case while populating when time crosses 12 hrs. Can any one help me in checking this case and also i need to feed the current date as input .
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7912
Location: Bellevue, IA

PostPosted: Fri Oct 14, 2016 11:42 pm    Post subject:
Reply with quote

You are getting precisely what you told the computer you wanted:
Code:
SELECT CAST(VARCHAR_FORMAT(GREGORIAN_DATE,'MM/DD/YYYY') AS CHAR(10)),
 CAST('|' AS CHAR(1)),
 CAST(VARCHAR_FORMAT(GREGORIAN_DATE,'YYYY.MM.DD') AS CHAR(10)),
so you cannot say anything else is expected -- you didn't provide any code to use a previous date, so you won't get one.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Fri Oct 14, 2016 11:58 pm    Post subject:
Reply with quote

Try,
Code:
 select case when current time  - 1 Hour <= '23:59:59' then  VARCHAR_FORMAT(current date - 1 day,'MM/DD/YYYY')
  else VARCHAR_FORMAT(current date,'MM/DD/YYYY') ) end
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Sat Oct 15, 2016 12:11 am    Post subject:
Reply with quote

Rohit Umarjikar wrote:
case when current time - 1 Hour <= '23:59:59'

I might be missing something. but won't this be always true?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Sat Oct 15, 2016 12:28 am    Post subject:
Reply with quote

That's right!!, How about this?
Code:
  select
  case when (current time  > '23:59:59' AND
             current time      <= '00:59:59') then
    VARCHAR_FORMAT(current date - 1 day,'MM/DD/YYYY')
  else VARCHAR_FORMAT(current date,'MM/DD/YYYY')  end 
     from sysibm.sysdummy1
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Sat Oct 15, 2016 1:21 am    Post subject: Reply to: Get correct date and time when current time is over 12 hrs
Reply with quote

why the
Code:
- 1


wouldn' t
Code:
current time <= '00:59:59'

be enough
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Sat Oct 15, 2016 1:43 am    Post subject:
Reply with quote

Took out -1(assuming"fetch sales data for every past 1 hour" done before) but I guess range is still needed, after 24:00:00 even though we are entering into next day and that's technically true but here TS wants to go back 1 hour which then gets us back to previous day date but TS unable to get that date instead getting the next date. So basically TS wants previous date only when it is between midnight till 1am.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Sat Oct 15, 2016 1:59 am    Post subject:
Reply with quote

Rohit Umarjikar wrote:
How about this?
Code:
  select
  case when (current time  > '23:59:59'
Will this ever be true?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Sat Oct 15, 2016 2:07 am    Post subject:
Reply with quote

I realize now that I can't think of good, it is Friday too. I should go home better icon_smile.gif
After all your comments , this should work and have a Good Weekend!!
Code:
select
   case when (current time      <= '00:59:59' )
               then
     VARCHAR_FORMAT(current date - 1 day,'MM/DD/YYYY')
   else VARCHAR_FORMAT(current date,'MM/DD/YYYY')  end 
      from sysibm.sysdummy1
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 983
Location: Oostende, Belgium

PostPosted: Sat Oct 15, 2016 2:11 am    Post subject:
Reply with quote

Has anyone actually thought about what happens if the job is held up and doesn't run until 2 hours later?

'nuff said...
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Mon Oct 17, 2016 9:40 pm    Post subject: Reply to: Get correct date and time when current time is over 12 hrs
Reply with quote

Hi All,

Thanks every one for the inputs.
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Tue Oct 18, 2016 2:36 am    Post subject: Re: Reply to: Get correct date and time when current time is over 12 hrs
Reply with quote

Hi Enrico,

i have tried to use only one condition as advised but i couldn't get
columns '00- 23' as per subselect query(i,e) SELECT 00-23 from SYSIBM.SYSDUMMY1. Could you please help me what is missing here.
Code:

SELECT 
   CASE WHEN (CURRENT_TIME  <= '00:59:59' )  THEN
    VARCHAR_FORMAT(CURRENT_DATE - 1 day,'MM/DD/YYYY')
    ||CAST('|' AS CHAR(1))
    ||VARCHAR_FORMAT(CURRENT_DATE - 1 day,'MM.DD.YYYY')
    ELSE
 VARCHAR_FORMAT(CURRENT_DATE,'MM/DD/YYYY')
||CAST('|' AS CHAR(1))
||VARCHAR_FORMAT(CURRENT_DATE,'MM.DD.YYYY')
END AS DATE
CASE WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 1 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 1 HOUR)
          THEN CAST ('CURRHOUR' AS CHAR(8))
     
     WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 2 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 2 HOUR)
          THEN CAST ('PREVHOUR' AS CHAR(8))

     WHEN GREGORIAN_DATE  = CURRENT_DATE AND
          COL2 >= HOUR(CURRENT_TIME) 
          THEN CAST('OPENHOUR' AS CHAR(8))

ELSE CAST('CLSDHOUR' AS CHAR(8))  END,
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 2 HOUR)),9,2)
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 1 HOUR)),9,2)
CAST('|' AS CHAR(1))

FROM TEST.CALENDER_TABLE ,
(SELECT  00 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  01 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
  SELECT  02 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  03 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  04 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  05 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  06 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  07 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  08 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  09 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  10 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  11 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  12 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  13 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  14 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  15 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  16 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  17 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  18 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  19 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  20 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  21 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  22 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  23 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL)  AS  A
WHERE GREGORIAN_DATE =  CURRENT_DATE
ORDER BY GREGORIAN_DATE,COL2
WITH UR;
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Wed Oct 19, 2016 1:26 am    Post subject: Getting low values in output file
Reply with quote

Hi Every one ,
I am able to see the output in my file . However I am seeing the low values in my output file at column 23rd position(i,e) after date format(YYYY.MM.DD) .Not sure what is the issue . Can any one help me on this?

Code:

SELECT
(
SELECT WHEN CURRENT_TIME  <=  '00:59:59'  THEN
CAST(VARCHAR_FORMAT(CURRENT_DATE - 1 DAY,'MM/DD/YYYY') AS CHAR(10))
||CAST('|' AS CHAR(1))
||CAST(VARCHAR_FORMAT(CURRENT_DATE - 1 DAY,'YYYY.MM.DD') AS CHAR(10))
||CAST('|' AS CHAR(1))
ELSE
CAST(VARCHAR_FORMAT(CURRENT_DATE,'MM/DD/YYYY') AS CHAR(10))
||CAST('|' AS CHAR(1))
CAST(VARCHAR_FORMAT(CURRENT_DATE,'YYYY.MM.DD') AS CHAR(10))
||CAST('|' AS CHAR(1))
END FROM SYSIBM.SYSDUMMY1) AS A,
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(COL2),9,2),
CAST('|' AS CHAR(1)),

CASE WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 1 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 1 HOUR)
          THEN CAST ('CURRHOUR' AS CHAR(8))
     
     WHEN GREGORIAN_DATE  = DATE(CURRENT_TIMESTAMP - 2 HOUR) AND
          COL2 = HOUR(CURRENT_TIME - 2 HOUR)
          THEN CAST ('PREVHOUR' AS CHAR(8))

     WHEN GREGORIAN_DATE  = CURRENT_DATE AND
          COL2 >= HOUR(CURRENT_TIME) 
          THEN CAST('OPENHOUR' AS CHAR(8))

ELSE CAST('CLSDHOUR' AS CHAR(8))  END,
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 2 HOUR)),9,2)
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(HOUR(CURRENT_TIME - 1 HOUR)),9,2)
CAST('|' AS CHAR(1))

FROM TEST.CALENDER_TABLE ,
(SELECT  00 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  01 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
  SELECT  02 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  03 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  04 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  05 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  06 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  07 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  08 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  09 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  10 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  11 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  12 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  13 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  14 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  15 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  16 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  17 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  18 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  19 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  20 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  21 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  22 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL
 SELECT  23 AS COL2 FROM SYSIBM.SYSDUMMY1 UNION ALL)  AS  A
WHERE GREGORIAN_DATE =  CURRENT_DATE
ORDER BY GREGORIAN_DATE,COL2
WITH UR;



Output file:-
Code:

10/18/2016|2016.10.18|.|00|CLSDHOUR|12|13|
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Wed Oct 19, 2016 3:10 am    Post subject: Reply to: Get correct date and time when current time is over 12 hrs
Reply with quote

Quote:
SELECT WHEN CURRENT_TIME <= '00:59:59' THEN
CAST(VARCHAR_FORMAT(CURRENT_DATE - 1 DAY,'MM/DD/YYYY') AS CHAR(10))
||CAST('|' AS CHAR(1))
||CAST(VARCHAR_FORMAT(CURRENT_DATE - 1 DAY,'YYYY.MM.DD') AS CHAR(10))
||CAST('|' AS CHAR(1))
ELSE
CAST(VARCHAR_FORMAT(CURRENT_DATE,'MM/DD/YYYY') AS CHAR(10))
||CAST('|' AS CHAR(1))
CAST(VARCHAR_FORMAT(CURRENT_DATE,'YYYY.MM.DD') AS CHAR(10))
||CAST('|' AS CHAR(1))
END FROM SYSIBM.SYSDUMMY1) AS A,
CAST('|' AS CHAR(1)),
SUBSTR(DIGITS(COL2),9,2),
CAST('|' AS CHAR(1)),

You have a '|' before end of select and another '|' after end of select. That makes 2 continuous '|'.

.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Oct 19, 2016 3:18 am    Post subject:
Reply with quote

what is the relationship between A and TEST.CALENDER_TABLE ?
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Wed Oct 19, 2016 3:41 am    Post subject:
Reply with quote

Hi Rohit,

Now there is no relation as it was required when GREGORIAN DATE is fetched from it . I have removed '|' after select but still getting the same data in output file.
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Wed Oct 19, 2016 3:42 am    Post subject:
Reply with quote

Hi Rohit,
Output file data looks like
Code:


10/18/2016|2016.10.18|.00|CLSDHOUR|12|13|
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Oct 19, 2016 10:12 am    Post subject:
Reply with quote

there is no relationship then why you have it?
Code:
SUBSTR(DIGITS(COL2),9,2),
why you need this ? you can use a col2 by itself, right?
Back to top
View user's profile Send private message
balaji81_k

New User


Joined: 29 Jun 2005
Posts: 86

PostPosted: Wed Oct 19, 2016 8:36 pm    Post subject:
Reply with quote

Yes Rohit you are correct we can use by itself .But still getting the low values in my output file .Please advise.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Wed Oct 19, 2016 9:08 pm    Post subject: Reply to: Get correct date and time when current time is over 12 hrs
Reply with quote

Code:
SELECT
 (
 SELECT WHEN CURRENT_TIME  <=  '00:59:59'  THEN

You are missing the word 'CASE' before 'WHEN'. I am not sure how your query would run without a mention of 'CASE'.

And if you are just missing that in this post, then you may well be missing some other fields as well. You need to break your query field by field and verify.

.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us