Re: SQL newbie question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Yes, although it is a relatively risky operation. The gist of it is, 
you can run STRQMQRY with an appropriate UNION of the existing 
contents and whatever is being added. The output from STRQMQRY can be 
*OUTFILE - and here's the scary part - it can be the file you are 
reading in the SELECT. In toher words, you can replace the contents 
of a file with STRQMQRY in place - no confirmation appears, etc.

I do this often to eliminate duplicate records. E.g., you could put

select distinct * from somefile

into a QMQRY. Then run

strqmqry thisqry output(*outfile) outfile(somefile) outmbr(*first *replace)

Note that "somefile" is the same file in both the select and in the outfile.

WARNING: We are professionals - don't try this at home!

;-)
Vern

At 07:27 PM 11/10/2005, you wrote:

> "Wilt, Charles" wrote:
> > Assuming that the a key collision means the rest of the record is the
> > same too, then all you need is:
> > Insert into myfile (
> > Select <....>
> > Union distinct
> > Select <....>
> > Union distinct
> > Select <....> )
>
> Yes, but is there a convenient way to UNION what's going into a file 
> with what's already there?
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.