Re: SQL Insert question

On May 9, 2023, at 6:01 PM, Glenn Gundermann <glenn.gundermann@xxxxxxxxx> wrote:

Hi Greg,

Perhaps I don't understand the question completely.

First, I'm assuming the additional fields have the appropriate default
values.

Would either of these two ideas work for you?

1. INSERT INTO part_master_audit
(list of mart_master columns)
SELECT *
FROM part_master
WHERE ...

2. Create a LF to part_master_audit with only the columns present in both
files. Then
INSERT INTO part_master_audit_LF
SELECT *
FROM part_master
WHERE ...

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.