We are porting an application that runs on DB2/Linux to be able to run on DB2/AS400. We are having problems with the sorting order, since our application is hosted on Windows, which uses ASCII , but the AS400 uses EBCDIC.

I understand that the way to do this is by defining the collating sequence perhaps thru a collate table. I also understand that there is an API to do that. However, our application is sold to customers, and the database needs to be created using scripts.

Is there a way to define a collate table on an AS400 database which will sort the database according with ASCII rules? Can that be done using scripts? Any example would be usefull.

Another thing: I read somewhere that in the case of teh AS400, the collating sequence has to be defined at the table level, not the database level.

Please help! Thanks!