Inserting record - two behaviours

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pxraja
Participant
Posts: 142
Joined: Fri Mar 14, 2008 10:22 am

Post by pxraja »

chulett wrote:Use a Sequential File stage to capture rejects, not a Hashed File, you could be losing records due to the 'destructive overwrite' nature of hashed files depending on the keys you've defi ...
Hi chulett,

all the rejected records got in the HASH FILE are inserted successfully to the same target table without any errors, but I want to understand why its throwing warnings like "Inconsistent datatype: expected number got DATE" for the rejected records which are valid.

I will also try with the sequential file stage to capture rejects.

Thanks in advance
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I've already said more than once what I think you should check / do, see my 3rd post for that. Don't really see a need to repeat it. Again.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”