Better INSERT statement

[Patrick Conner <PWConner@xxxxxxxxxxx>]

Is there a better way to insert records when wanting to add records to a
file from an identical file while avoiding duplicate records?

insert into lib1.file1
 select * from lib2.file1
  where (key1 || key2 || key3 ||
         key4 || key5 || char(key6))
    not in (select
             (key1|| key2 || key3 ||
              key4 || key5 || char(key6))
            from lib1.file1)

--
Privileged and Confidential.  This e-mail, and any attachments there to, 
is intended only for use by the addressee(s) named herein and may 
contain legally privileged or confidential information.  If you have 
received this e-mail in error, please notify me immediately by a return 
e-mail and delete this e-mail.  You are hereby notified that any 
dissemination, distribution or copying of this e-mail and/or any 
attachments thereto, is strictly prohibited.