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.

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

Processing your response...

Discuss This Question: 3 &nbspReplies

There was an error processing your information. Please try again later.

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

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.

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

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

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

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