Change sorting order on a repeating grid (EBCDIC)
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
***Edited by Moderator Marissa to update categories and add SR Details***