Delete 72 hours old record from a file using SQLRPGLE

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

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.
    
    49,720 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following