I've got a job which sorts by a Timestamp-field (read from DB2 API with microseconds flags, non-nullable in DB). On execution, I get the following error after about 3 Mio. rows:
Code: Select all
Sort_123,2: Trouble encoding sort keys: Field "xxx" has keyprep export format error; value: **************************
Is this a known problem in DS 7.5.3? I'm now using a Char field instead which is not ideal but seems to work.