Warning when using Sequential Fileproperty Row Number Column

[thebird]

Hi,

In my job I am generating the Row Number Column when reading from a sequential file by setting the stage's Row Number Column property.

I get a warning in the director that says -

When checking operator: When binding input interface field "RowNum" to field "RowNum": Implicit conversion from source type "uint64" to result type "int32": Possible range limitation.

The column passes through quite a few stages without any issues before it reaches the final transformer stage, where the warning is shown.

I have ste the data type of this column to Integer everywhere and I have RCP on.

Can anyone tell me why this warning appears? Also a way to get rid of this warning.

Regards,

The Bird.

[ray.wurlod]

The message itself says it all. Check the schemas rather than the "SQL" column definitions. At one point you have the column declared as an unsigned long integer (uint64); subsequently you load that value into a column designated as a signed integer (int32). The warning alerts you to the fact that not every uint64 can be stored in an int32.