× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2005

Re: SQL newbie question

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.