Problem:
A query from UDB tables may issue a wrong sort sequence, if characters and digits are involved in the order by column. Alphanumeric values are ordered in the ASCII collating sequence, digits before letters. The ordering does not correspond with host DB2 data retrieved by UDB DB2 Connect.
Resolution:
The collating sequence can be specified while creating a UDB location with HCO Create Database. The collating sequence must be set to MFE = EBCDIC in Options - Codepage - Mainframe Express.
Old KB# 2607
#MFDS
#EnterpriseDeveloper
