When reading database column INT32 into column VARCHAR(min=0

[kollurianu]

Hi All ,

I am getting the following warning

max_daily_position_id: Schema reconciliation detected a size mismatch for column KEY_LABEL. When reading database column INT32 into column VARCHAR(min=0,max=1), truncation, loss of precision or data corruption can occur.

But KEY_LABEL is a dummy column with a constant '1' ..


select
1 key_label,
a.max_key max_daily_position_key
from
(select max(daily_position_id) + 1 max_key from abc..daily_position) a

any thoughts?

[asorrell]

No, it isn't a constant '1', it is constant 1. In your SELECT statement you do not have it in quotes, so it is numeric and is being returned as an integer. And the DataStage column you are loading into is defined as VarChar(1), hence the mismatch.

Switch one or the other so the types match.