WRKQRY query

2,410 pts.
Tags:
AS/400
iSeries
WRKQRY
In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.

Software/Hardware used:
As400
ASKED: April 23, 2013  10:44 AM
UPDATED: April 23, 2013  12:02 PM

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: 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
  • philpl1jb
    http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/c4152104.pdf pages 111-114 To see the collating sequence - select collating sequence - Enter Collating sequence option 3 .. (Define the Sequende) F15 will show the language sequence (for your computer this is English ) F14 will show hexadecimal sequence The sequence used will determine sort order and greater then / less then logic F23 will allow you to save a sequence as the default. Option 3 allows you to modify the sequence .. it has upper case = lower case a=70 and A=70. So A and a will be sorted as equal.
    48,565 pointsBadges:
    report
  • TomLiotta
    Option 2 on your system causes Query to use the collating sequence for English. On someone else's system, the option might show a different language or it might not be shown at all. Language collating sequences are often different from a hexadecimal sequence. For most things that involve a person looking at results, you should use the language sequence that is associated with that user. -- Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    And you might want to test a query using option 3=Define the sequence. Change the sequences of some characters to see how it changes sorted results or changes comparisons for 'greater than', 'less than' or 'equals' in the test query that you create. -- 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