1
  • Expand Counter Size in 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?

    chen755515 pointsBadges:
  • Query against User Profiles

    I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I'm querying this against to a outfile,i was able to select the columns what i want,but i couln't find...

    qmaster1,675 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
1

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