Metadata Mismatch

[pravin1581]

Hi All,

We are trying to load data from Db2 into SQL server 2005. But we are getting the following warning

Code: Select all

DSD.BCIOpenW results of SQLColAttributes(finAttDedAmt) gave MetaData mismatch
COLUMN.TYPE Expected = BigInt Actual = Numeric

where finAttDedAmt is the column name in the source and the destination tables. In the database we see that the datatype of the column is defined as BigInt and same is used in the job as well but still this warning is generated and it is happening for all the columns which have BigInt datatype.

Thanks in advance.

[ArndW]

I'm not sure if the ODBC interface supports BigInt as a datatype. Are values in the BigInt range (i.e. greater than what an Int can handle, for example 2147483649 ) correctly loaded?

[pravin1581]

I'm not sure if the ODBC interface supports BigInt as a datatype. Are values in the BigInt range (i.e. greater than what an Int can handle, for example 2147483649 ) correctly loaded? ...

Are you referring to the values that the field can hold. I looked into the database and there are some values as 5000000000, 16000000000 . If that is the case then what should be the solution, because we have also tried Integer datatype and it again gives warning

Code: Select all

DSD.BCIOpenW results of SQLColAttributes(column name) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Numeric

[chulett]

Why not change them to... Numeric?

[priyadarshikunal]

Have you tried importing metadata using orchestrate. if not then try it and see what datatype is returned.

also try to use "Numeric" datatype to see if the warning goes off.

[ray.wurlod]

Have you tried importing metadata using orchestrate.

Of course, posting in the server forum, they may be a server-only licence.

[suresh.angadi]

Hi Praveen,

Bigint support 8 byte so the vlues you have specified can be fit into that, problem is why it is giving the warning, please wether the MS SQL server supports the bigint datatype if not convert it the required datatype supported by MS SQL database and then use datatype conversion functions if required (see the datatype conversion map from help).

Regards
Suresh Angadi

Hi All,

We are trying to load data from Db2 into SQL server 2005. But we are getting the following warning

Code: Select all

DSD.BCIOpenW results of SQLColAttributes(finAttDedAmt) gave MetaData mismatch
COLUMN.TYPE Expected = BigInt Actual = Numeric

where finAttDedAmt is the column name in the source and the destination tables. In the database we see that the datatype of the column is defined as BigInt and same is used in the job as well but still this warning is generated and it is happening for all the columns which have BigInt datatype.

Thanks in advance.