Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Data that is returned from a Teradata query might not be sorted in ascending order. The incorrect sort order is caused by a limitation of Teradata. When this happens, an error message similar to the following is generated:

ERROR: Data set LIB.test is not sorted in ascending sequence. The
current BY group has group =
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb

. . .more data lines. . .

bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbharry and
the next BY group has group =
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb

. . .more data lines. . .

bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbdick.

Teradata sorts only the first 4096 bytes of data. Therefore, if the field upon which the sort key is based is greater than that, the data might not be returned in sorted order.

The only circumvention is to use data that is not more than 4096 bytes.

Operating System and Release Information