DSXchange

Posted: **Tue Jan 05, 2010 6:06 am**

Hello,
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: **************************

(the stars are really there)
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.

Posted: **Mon Jan 25, 2010 11:11 am**

Noone having an idea on this one?

Posted: **Mon Jan 25, 2010 12:10 pm**

Guess not. Seems to be saying that 3M rows or so in, you've got something it doesn't think is a valid timestamp.

Posted: **Mon Jan 25, 2010 7:32 pm**

Well DB2 thinks it is valid because it comes from there and goes there. So this is really strange...

Posted: **Mon Jan 25, 2010 9:23 pm**

Then perhaps there's a difference between what DB2 considers a valid timestamp and what DataStage does. Have you asked your official support provider?

DSXchange

Trouble encoding sort keys: Field "xy" has keyprep

Trouble encoding sort keys: Field "xy" has keyprep