Sure, why not?INSERT INTO CA1665AFTT.EMODESADV3
(E3CPRD, E3CQTY, E3ecsn, e3mena, e3hand)
SELECT prdc, oqty, '333', 'EDI400', 'MR1'
FROM Monica.emodI'm not sure if this is what you wanted. It does insert the constants into every row selected. In general, if you can SELECT the values, either as a table column or a constant or an expression, etc., you can insert it into the target table.