Page 1 of 1
Re: Insert error while loading the timestamp data
Posted: Fri Oct 23, 2009 10:50 am
by ray.wurlod
deesh wrote:Datastage taking as binary( 8 )
What precisely do you mean by this?
What data type is reported when you import the table definition using the orchdbutil facility?
Re: Insert error while loading the timestamp data
Posted: Sat Oct 24, 2009 1:16 am
by deesh
In sequel server datatype is Timestamp, but when i load the in datastage odbc stage its taking binary(8).
my source and target is timestamp
ray.wurlod wrote:deesh wrote:Datastage taking as binary( 8 )
What precisely do you mean by this?
What data type is reported when you import the table definition using the orchdbutil facility? ...
Posted: Sat Oct 24, 2009 10:34 am
by ray.wurlod
I still don't understand your meaning of "taking". Can you try to express this in different words?
Posted: Sun Oct 25, 2009 10:49 pm
by deesh
here taking means, while loading the fields in odbc, timestamp field instead of timestamp showing the binary datatype.
ray.wurlod wrote:I still don't understand your meaning of "taking". Can you try to express this in different words? ...
Posted: Mon Oct 26, 2009 5:51 am
by chulett
And what happens when you 'correct' the metadata? You are certainly not stuck with whatever it 'takes'.