<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Consolas;
}
@page WordSection1 {margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; MARGIN: 0in 0in 0pt
}
LI.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; MARGIN: 0in 0in 0pt
}
DIV.MsoNormal {
FONT-SIZE: 12pt; FONT-FAMILY: "Times New Roman","serif"; COLOR: black; MARGIN: 0in 0in 0pt
}
A:link {
TEXT-DECORATION: underline; COLOR: blue
}
SPAN.MsoHyperlink {
TEXT-DECORATION: underline; COLOR: blue
}
A:visited {
TEXT-DECORATION: underline; COLOR: purple
}
SPAN.MsoHyperlinkFollowed {
TEXT-DECORATION: underline; COLOR: purple
}
PRE {
FONT-SIZE: 10pt; FONT-FAMILY: "Courier New"; COLOR: black; MARGIN: 0in 0in 0pt
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Tahoma","sans-serif"; COLOR: black
}
SPAN.HTMLPreformattedChar {
FONT-FAMILY: Consolas; COLOR: black
}
SPAN.EmailStyle20 {
COLOR: #1f497d
}
.MsoChpDefault {
FONT-SIZE: 10pt
}
</style><style id="owaParaStyle">P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
</style>
</head>
<body lang="EN-CARRIBEAN" link="blue" bgcolor="white" vlink="purple" fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>There is a manual... on CISIS but mainly dealing with mx as the most important utility.</p>
<p>It can be downloaded from various sources.</p>
<p> </p>
<div>
<div class="BodyFragment"><font size="2"><span style="FONT-SIZE: 10pt">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<div style="FONT-SIZE: 16px; FONT-FAMILY: Times New Roman; COLOR: #000000">
<hr tabindex="-1">
<div id="divRpF407998" style="DIRECTION: ltr"><font color="#000000" size="2" face="Tahoma"><b>From:</b> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of Bridgette Heron [nlj_bmheron@hotmail.com]<br>
<b>Sent:</b> Tuesday, October 13, 2015 9:36 PM<br>
<b>To:</b> isis-users@iccisis.org<br>
<b>Subject:</b> [Isis-users] FW: MX utility query - solved<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="COLOR: #993366">Hi everybody,</span></p>
<p class="MsoNormal"><span style="COLOR: #993366"></span> </p>
<p class="MsoNormal"><span style="COLOR: #993366">Ernesto has done it again. My problem is solved and 1 more lesson learnt from our genius
</span><span style="FONT-FAMILY: Wingdings; COLOR: #993366">J</span><span style="COLOR: #993366"></span></p>
<p class="MsoNormal"><span style="COLOR: #993366">See solution below in his email. I love the versatility of the mx command. There should really be a manual on it.</span></p>
<p class="MsoNormal"><span style="COLOR: #993366"></span> </p>
<p class="MsoNormal"><span style="COLOR: #993366">Bridgette</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d"></span> </p>
<p class="MsoNormal"><span style="COLOR: #1f497d"></span> </p>
<div>
<div style="BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0in; PADDING-TOP: 3pt; PADDING-LEFT: 0in; BORDER-LEFT: medium none; PADDING-RIGHT: 0in">
<p class="MsoNormal"><b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; COLOR: windowtext">From:</span></b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"; COLOR: windowtext"> isis-users [mailto:isis-users-bounces+nlj_bmheron=hotmail.com@iccisis.org]
<b>On Behalf Of </b>spinaker<br>
<b>Sent:</b> Monday, October 12, 2015 4:25 PM<br>
<b>To:</b> isis-users@iccisis.org<br>
<b>Subject:</b> Re: [Isis-users] MX utility</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Dear Bridgette<br>
<br>
In first place I want to congratulate you because a database with more then 140 thousand records is really interesting<br>
By the Way, what kind of library you manage and where is it located?<br>
<br>
Ok, let's go to work<br>
Out of curiosity, how do you get your hit of records, i.e. is the term 'pioj' indexed in any way?<br>
do you extract that term using some sort of FST?<br>
<br>
I suppose that your bool=pioj is correct, so the way to do this is: <br>
<b><span style="FONT-FAMILY: "Courier New""><br>
mx dbase bool=pioj proc='d.' copy=dbase now -all tell=1000</span></b><br>
<br>
The way to delete the record is copying the process onto the same database, otherwise the result is only to the console, but has no effect on the master file<br>
let's note that you cannot export records wiht a proc='d.' because you cannot create deleted records !!!<br>
<br>
then ... please ... backup yuour database before you begin with the killing !!!<br>
<br>
good luck<br>
Ernesto Spinak<br>
<br>
<br>
<br>
<br>
El 12/10/2015 a las 18:05, Bridgette Heron escribió:</p>
</div>
<blockquote style="MARGIN-BOTTOM: 5pt; MARGIN-TOP: 5pt">
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">Hello all,</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">I have a database of 142,747 records and I want to delete all records with the term ‘pioj’ . The search from Winisis yields 59775 records so its too many to delete.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">I tried the mx utility.</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""> Mx dbase bool=pioj proc=’d.’</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">Thought it would logically delete them so I could export/import to load back the records I want to keep. The command runs but no effect when in Winisis i.e. records with
the term pioj are not flagged as logically deleted. </span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">Shed some light please. Thanks</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif"">Bridgette</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 10pt; FONT-FAMILY: "Tahoma","sans-serif""></span> </p>
<p class="MsoNormal"><br>
<br>
<br>
</p>
<pre>_______________________________________________</pre>
<pre>isis-users mailing list</pre>
<pre><a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a></pre>
<pre>To manage your own subscription options go to: <a href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a></pre>
<pre>Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" target="_blank">hlrutten@xs4all.nl</a></pre>
</blockquote>
<p class="MsoNormal"><br>
<br>
<br>
</p>
<pre>-- </pre>
<pre> .^. .^.</pre>
<pre> ( ) ( )</pre>
<pre> === ===</pre>
<pre> =[=]================================[=]=</pre>
<pre> | | Ernesto Spinak | |</pre>
<pre> | | <a href="mailto:spinaker@adinet.com.uy" target="_blank">spinaker@adinet.com.uy</a> | |</pre>
<pre> | | Montevideo, Uruguay | |</pre>
<pre> | | tel/fax (598) 2622-3352 | |</pre>
<pre> | | celular (598) 99612238 | |</pre>
<pre> =[=]================================[=]=</pre>
<pre> === ===</pre>
<pre> ( ) ( )</pre>
<pre> V V </pre>
</div>
</div>
</div>
</div>
</body>
</html>