Question
Change sorting order on a repeating grid (EBCDIC)
Hi All,
we have a business requirement in which they want to present some information on a repeating grid, this information needs to be presented on an specific order, following the EBCDIC order. This due they need to compare this Data from Pega with other system which uses DB2 and EBCDIC.
I know the sorting is driven by the Data Base, our current system is using DB2 as well but was installed using UNICODE encoding instead of EBCDIC, not sure if having the schema under EBCDIC would made a difference, I'm looking for some insight on how to change the current ASC sorting order data is presented within Pega.
We are using Pega 7.2 and BD2 as mentioned before.
EBCDIC sort order https://en.wikipedia.org/wiki/EBCDIC
Thank you!
JC
***Edited by Moderator Marissa to update categories and add SR Details***
Thanks Prasanth,
the code on that link is not working as expected, I'm still trying to find a solution to the issue, there is a need to compare byte to byte to complete the sorting. thanks for the help.
JC
Hi JC,
I think unicode encoding and EBCDIC way are different so i think we need to right a Java function to convert from the unicode format to EBCDIC and then sort it
I think this link would help you implementation
https://coderanch.com/t/681070/java/EBCDIC-sort-order-Java
Regards
Prasanth