Delete 72 hours old record from a file using SQLRPGLE

mcasantoshrai
55 pts.
Tags:
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: Last updated:
Related Questions

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • philpl1jb 
    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.
    54,090 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: