Home > IT Answers > AS/400 > Delete 72 hours old record from a file using SQLRPGLE
mcasantoshrai
55 pts.
 Delete 72 hours old record from a file using SQLRPGLE
AS/400, SQLRPGLE
I have a file containing two fields...First one contains date with century and second one contains time in time stamp format. I want to delete 72 hours old record from this file using SQLRPGLE.

Software/Hardware used:
AS400
ASKED: February 2, 2013  11:09 AM
UPDATED: February 4, 2013  1:45 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,390 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please describe what you mean by “TIME STAMP FORMAT”. An actual TIMESTAMP column includes a date part. That would make the first date value column unnecessary. — Tom

TomLiotta
 107,845 pts.
  
Our code depends on the field types and actual data.

FIRST ONE CONTAINS DATE WITH CENTURY

so date looks like this 20130225 ??? 
is the field type date, numeric, char.


 
and the other TIME IN TIME STAMP FORMAT 
show us that and tell us what type it actually is.
philpl1jb
 44,110 pts.