Sort Date/Time in WRKJOBSCDE in AS/400

45 pts.
Tags:
AS/400
AS/400 administration
WRKJOBSCDE
WRKJOBSCDE AS/400
How to sort by Date/Time in WRKJOBSCDE.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Unless there is some API to do this, you would need to output(*PRINT) and then have a program copy the report to a disk file and manipulate the data in that file.

Discuss This Question: 3  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
    I'm not aware of any sorting in WRKJOBSCDE other than the default by name. If sorting is needed, you might need to use the List Job Schedule Entries (QWCLSCDE) API to list the entries into a user space. You can then retrieve entries into whatever container you feel comfortable sorting or you can sort the space directly if you're comfortable with that. You'll then need some form of display to view the items. If you only want to view the items and you retrieved the user space entries into a database file, you can probably get by with just a RUNQRY command. You might consider a User Defined Table Function (UDTF) that does the whole job, calling the API and returning entries into a table format. Tom
    125,585 pointsBadges:
    report
  • WoodEngineer
    This should do what you want: WRKJOBSCDE SEQ(*DATETIME) I am not sure when this option became available. We are running V5R4.
    6,365 pointsBadges:
    report
  • TomLiotta
    The SEQ(*DATETIME) is either the right answer or as close as it gets. Good catch. Tom
    125,585 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