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
job is aborted due to mismatch
Moderators: chulett, rschirm, roy
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.
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.