×
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.
Hi Joel
QM queries can be a very nice way to do this. When you run a query there, you can set the output to an *OUTFILE, and the outfile can be the one you are querying.
Actually you can use the DOCSQL command in RJSIMAGE -
DOCSQL 'select distinct * from yourlib/yourfile order by somekey' output(*outfile) outfile(yourlib/yourfile)
That's it - of course, you might want to do this to a non-production location, right? Or maybe not!
This is a VERY SCARY feature of query management queries - there is no warning message that you are doing a replacement in place of the entire contents of the file.
So be ver-r-r-ry careful!
:)
HTH
Vern
----- Original Message -----
For testing, what is a simple and quick method of sort & data reduction by removing dup records?
I thought of TAATOOLS SORTDB but there is no data reduction option.
Is SQL distinct going to be the ticket?
Thanks!
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
midrange.com
