Insert error while loading the timestamp data

ray.wurlod · Post by **ray.wurlod** » Fri Oct 23, 2009 10:50 am

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?

deesh · Post by **deesh** » Sat Oct 24, 2009 1:16 am

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? ...

ray.wurlod · Post by **ray.wurlod** » Sat Oct 24, 2009 10:34 am

I still don't understand your meaning of "taking". Can you try to express this in different words?

deesh · Post by **deesh** » Sun Oct 25, 2009 10:49 pm

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? ...

chulett · Post by **chulett** » Mon Oct 26, 2009 5:51 am

And what happens when you 'correct' the metadata? You are certainly not stuck with whatever it 'takes'.

DSXchange

Insert error while loading the timestamp data

Re: Insert error while loading the timestamp data

Re: Insert error while loading the timestamp data