Try adding OVERRIDING SYSTEM VALUE here:
<pre>INSERT INTO destination table OVERRIDING SYSTEM VALUE SELECT * FROM origin table
Without knowing more than what you show, it’s hard to be about exact syntax or even if it’s appropriate. There’s no way to be sure that the schemas match up between QMF and interactive SQL, nor if the same user is involved, nor if there are session settings that are set, nor almost anything else.
Given this error — Value cannot be specified for GENERATED ALWAYS column field1. — it’s hard to accept that the two scenarios, QMF and interactive SQL, are operating on the same table with the same statements unless the two sessions are configured differently.