Hi, Homebrew01/Jeff,

Following Homebrew01' idea, I did some tests and would like to share the findings with you:

these data type mappings from SQL Server 7 to AS400(i5 v5r3) Db2 work:

(sql server)...

Thank you for the advice. I tried. But, no, DB2 doesn't allow me to change table data type from varchar to numeric, vice versa. Not even with an empty table....