Results 1 to 4 of 4

Thread: Special characters sorting and data selection

  1. #1

    Special characters sorting and data selection

    We are on E1 apps 9.0, tools 9.1.4.7.

    We have a request to have a report that will have data selection for RPRMK in F0411 to be LIKE 'BKGD'. In JDE we do not have the option to do a LIKE, so we have to select a range such as from 'BKGD' thru 'BKGDZZZZZZZZZZZZZZZZZ'.

    But what if we encounter a special character. We are seeing in our test data that this field could have a value of 'BKGD/ABCD'. This BKGD/ is being selected by our data selection, which is what we want. But i've not been able to found exactly how special characters are treated in data selection.

    I've looked but could not find a collating or sorting sequence list in JDE that would tell my exactly how special characters are treated when they are found in a field being used for a data selection range.

    Also, would be interested in any other ways are treating a request to do a LIKE in JDE.

    Thanks for your input

  2. #2
    Member David Robertson's Avatar
    Join Date
    Nov 2000
    Location
    UK
    Posts
    271
    The collating sequence depends on your database that is executing the SQL. Look to your database documentation for info on options for collating sequences and where the special characters are ranked in that.
    As you've said, you create a range, from BKGD and right pad with the lowest character in your collating sequence (usually blank), and BKGD and right pad with the highest character in your collating sequence (usually Z or 9).

    Developer / CNC
    E9.1 TR 9.1.4.6 AS/400
    WebSphere 8.5.0.2 AS/400
    DB2 AS/400

  3. #3
    Member
    Join Date
    Mar 2002
    Location
    Minneapolis, MN
    Posts
    772
    Well I don't have a "UBE data selection" solution for you. However, if you wanted to make the report a "2-stage" report, what you're asking can be done. You could use a c-bsfn to extract the data you need and store that data in a temporary table (work file), then run the report over the records in the work file.

    The c-bsfn can utilize the JDB_ api, which does allow for the use of LIKE comparisons. See JDB_SetSelectionX and any examples you can find in base code. Unfortunately, I am not at a place right now where I can look up that detail and I don't have it committed to memory. but you will populate a a certain member of a NEWSELECTSTRUCT data structure with the comparison value that represents LIKE.
    Jeremy
    E1 Consultant
    Minneapolis, MN

  4. #4
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,275
    Special chars will all have an ASCII value (and decimal value) and that is the sequence fields are sorted in

    Look here and you'll see that & is greater than % for example

    https://www.asciitable.com/
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.