Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

PN5_60554

Description

jQL: Enable caseless sorting of attribute data.

Requires case_insensitive_jql_sort_attributes = true, which is set by default for the D3 emulation. 

jQL still only sorts using the columns specified, for example: 

  • LIST FILE BY *A0 BY *A1 *A1 

Will look very different from: 

  • LIST FILE BY *A0 BY-EXP *A1 *A1 

In the first statement, only the first MV of *A1 will be used in the sort, using BY-EXP cause all items in *A1 to be sorted caseless. 


Previous Release Behavior

All sorts where alpha numeric, e.g. McMURPHY would sort after MURPHY. 


Current Release Behavior

When sorting, all attribute data is sorted caseless, e.g. McMURPHY = MCMURPHY = mcmurphy 

Was this article helpful?