Expand Counter Size in WRKQRY

15 pts.
Tags:
AS400 -WRKQRY
WRKQRY
I use WRKQRY to produce a summary file. I use '5' to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?

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
    Your best choice is to stop using the old, almost obsolete WRKQRY function. Use STRQM to create Query Manager queries instead.   But if you must use WRKQRY for some strange reason (and I'd like to know what it is), you can usually only make that type of change for a summary field by creating Result Fields with larger sizes. In your case, though, I'm not at all sure what can increase a 'Count' field. Counting more than ten million of anything seems a little extreme for WRKQRY. There might not be any good way of doing it.   You could just create a SQL VIEW that does a COUNT() and use WRKQRY to report it, I suppose. That would give you 'Count' values as big as you might imagine.   Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    There is no way to make the counter field.  As Tom suggested you could make a result field (15,0) and set it's value = 1.    Then sum the result field. 
    49,840 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