Re: SQL Insert question

[DFreinkel <dfreinkel@xxxxxxxxxxxxxxxxx>]

Try define each file as a data structure then insert using the data structure 

Darryl Freinkel 

Sent from my iPhone

> 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.