I created a table like this

create table T1 (F1 int)

On MSSQL and Oracle, such insert statement:

insert into T1 (F1) values ('3')

would work, but not on DB2.

Is there a way to make DB2 automatically convert the value like MSSQL and Oracle can do?

Thanks.
Tawee.

The correct syntax in DB2 is:
insert into T1 (F1) values (3)

You might be able to use the CAST fucntion:
insert into T1 (F1) values (cast '3' as integer)
but I am not sure if this will work.