Unable to sort on Longvarchar field

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
smart2786
Premium Member
Premium Member
Posts: 14
Joined: Sun Mar 11, 2007 10:16 pm
Location: India

Unable to sort on Longvarchar field

Post by smart2786 »

Hi Experts,

i am getting an error when i am trying to sort longvarchar (99999999) filed.

here is the fatal error from log:

"Trouble encoding sort keys: Variable-length key "MASTER_KEYS" length too large (32779), limit is 32767"

i defined field with longvarchar but i do not why job log giving error massage with varchar

Can any one suggest best method to over come this issue??

Thanks lot
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”