DSXchange

Hi all ,

my job is aborted ,
field sql type length scale

input nav decimal 18 2
target is sql server nav numeric 15 2


i got follwing first warning.

Ldnavtable..ODBC_2.DSLink4: DSD.BCIOpenW results of SQLColAttributes(nav) gave MetaData mismatch
COLUMN.TYPE Expected = Numeric Actual = Integer


what might be the reason

Harithay,

your database has the column defined as an INTEGER and in your column definition in the ODBC stage you have defined it as a floating point number with 2 decimal places; DataStage is telling you that it doesn't like what you've done.

Change your column definition to that of an integer data type and you will be able to continue.

Thank you arndw,

you are ryt , my dba has changed its data type in the target . i don't know that.