Hi There,

I wonder if the following pair will be considered as same data type or not:

char(15) - char(18)
char(15) - varchar(18)

When I link the two columns char(15) to char(18), would DB2 do casting or not?

Thanks

The length is completely irrelevant for type propagation considerations. Thus, you can't overload UDFs with CHAR(15) and CHAR(18), for example.