The purpose of this paper is to provide an explanation of how the iSeries sorts data and how you can make adjustments to the sorting sequence. This is important because EBCDIC-based systems sort data alpha characters first, then numeric characters, while ASCII data is sorted numeric first, then alpha characters. Domino for iSeries, although native on the iSeries server, still sorts data as an ASCII-based system. With this information you can understand how to change the sort order of data when retrieved from UDB DB2.
Did you find this white paper useful?
24 out of 50 users found this white paper useful
Related white papers
Data Mining and Customer Relationships by Kurt Thearling
The way in which companies interact with their customers has changed dramatically over the past few years. A customer's continuing business is no longer guaranteed. As a result, companies have...
Where’s My Customer? Spatial Modeling for Promotion Distribution
HYPERparallel, a leading data mining company, offers a set of data mining applications targeted to customer relationship marketing (CRM). This recipe integrates three technologies: HYPERparallel’s //Discovery (pronounced HYPERparallel Discovery) suite...
Deliver Business Intelligence to Microsoft® Excel, Powerpoint®, and Word
Format, sort, and organize data from your business intelligence reports just as they would any other Microsoft table or chart with MicroStrategy Office.
HABURI.com: The Virtual Factory Outlet
Haburi is a Japanese word, roughly translated to mean "good deal." By the time the company was conceived, all of the obvious names for an online retailer had been taken,...
Forecasting, Market Research and Competitive Intelligence At M-I Drilling Fluids
M-I Drilling Fluids is the largest drilling and completion fluids supplier in the world. When its Market Research Group wanted to better understand its customers' needs and develop new products...
Making Customers smile with Help from SAS
Founded in 1872 as the Loan and Deposit Department of the Co-operative Wholesale Society, the Co-operative Bank has always put customers first. They launched the United Kingdom's first successful full-service...
Media Planning Group Gets the Word Out: SAS Analytics Help Determine Advertising Strategies at MPG
With a client list that includes Microsoft, Intel, Isuzu and Peugeot, Media Planning Group (MPG) places advertising and tracks product awareness for some of the best-known brands in the world....
