<html><head></head><body><div style="color:#000; background-color:#fff; font-family:bookman old style, new york, times, serif;font-size:16px"><div id="yui_3_16_0_1_1444820128788_9369"><span id="yui_3_16_0_1_1444820128788_9504">Now, finally, what I recommend is to export the records into an empty database. So, the real records will appear, then update.</span></div><div></div><div id="yui_3_16_0_1_1444820128788_9356"><br></div><div id="yui_3_16_0_1_1444820128788_9356" dir="ltr">All databases in ISIS and Access are like that, they desappear fisically, but not logically. When you see the counter in Win Isis or ISIS, they are there. </div><div class="signature" id="yui_3_16_0_1_1444820128788_9371"><div id="yui_3_16_0_1_1444820128788_9370"><font color="#0000ff" size="4" id="yui_3_16_0_1_1444820128788_9838"><font color="#0000ff" size="5" id="yui_3_16_0_1_1444820128788_9837"><b id="yui_3_16_0_1_1444820128788_9836">__________________________</b></font></font></div><div id="yui_3_16_0_1_1444820128788_9387"><font color="#c00000" face="arial, helvetica, sans-serif" size="4" id="yui_3_16_0_1_1444820128788_9386">Un nuevo cambio de mentalidad se avecina...nuestro mundo, pronto no será ya el mismo. Los viejos patrones serán cosas del pasado y poco a poco el Todo será en todos...</font></div><div style="color:rgb(0, 0, 255);font-size:18px;font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9388">_________________________________________________________________</div><div style="font-size:18px;font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9389"><br></div><div style="font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9666"><span style="font-size:x-large;">Luis M. Peña Féliz</span></div><div style="font-size:18px;font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9665">- Bibliotecario de Procesos Técnicos</div><div style="font-size:18px;font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9656"> Biblioteca Pedro Mir, UASD</div><div style="font-size:18px;font-family:arial, helvetica, sans-serif;" id="yui_3_16_0_1_1444820128788_9664">- Encargado Centro de Documentación y Divulgación, Servicio Geológico Nacional</div><div style="color:rgb(0, 0, 255);font-size:18px;font-family:arial, helvetica, clean, sans-serif;" id="yui_3_16_0_1_1444820128788_9663"><br></div></div> <br><div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: bookman old style, new york, times, serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font size="2" face="Arial"> El Martes, 13 de octubre, 2015 12:12:03, spinaker <spinaker@adinet.com.uy> escribió:<br> </font> </div> <br><br> <div class="y_msg_container"><div id="yiv6616769979">
<div>
<div class="yiv6616769979moz-cite-prefix">Dear Bridgette<br>
<br>
The problem is a syntax error in your command<br>
<br>
you should use <b>mx secin bool=pioj proc='d.' </b><b><big>copy<font color="#cc0000">=</font>secin </big></b><b>now -all
tell=1000</b><b><br>
</b><br>
and you missed the <font color="#ff0000"><b>= </b></font>(equal
sign) in the command<br>
<br>
Regards<br>
Ernesto<br>
<br>
<br>
<br>
El 13/10/2015 a las 12:00, Bridgette Heron escribió:<br>
</div>
<blockquote type="cite">
<style><!--
#yiv6616769979
_filtered #yiv6616769979 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
_filtered #yiv6616769979 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
_filtered #yiv6616769979 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv6616769979 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered #yiv6616769979 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#yiv6616769979
#yiv6616769979 p.yiv6616769979MsoNormal, #yiv6616769979 li.yiv6616769979MsoNormal, #yiv6616769979 div.yiv6616769979MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";color:black;}
#yiv6616769979 a:link, #yiv6616769979 span.yiv6616769979MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv6616769979 a:visited, #yiv6616769979 span.yiv6616769979MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv6616769979 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";color:black;}
#yiv6616769979 p.yiv6616769979MsoAcetate, #yiv6616769979 li.yiv6616769979MsoAcetate, #yiv6616769979 div.yiv6616769979MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";color:black;}
#yiv6616769979 span.yiv6616769979EmailStyle17
{font-family:"Tahoma", "sans-serif";color:black;}
#yiv6616769979 span.yiv6616769979HTMLPreformattedChar
{font-family:"Consolas", "serif";color:black;}
#yiv6616769979 span.yiv6616769979EmailStyle20
{color:#1F497D;}
#yiv6616769979 span.yiv6616769979BalloonTextChar
{font-family:"Tahoma", "sans-serif";color:black;}
#yiv6616769979 .yiv6616769979MsoChpDefault
{font-size:10.0pt;}
_filtered #yiv6616769979 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv6616769979 div.yiv6616769979WordSection1
{}
--></style>
<div class="yiv6616769979WordSection1">
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;">Hi Ernesto,</span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;">Thank you for
responding </span><span style="font-family:Wingdings;color:#1F497D;">J</span><span style="color:#1F497D;"></span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;">The National
Library of Jamaica has been CDS/ISIS distributor since 1989.
We have collected records from other libraries and made one
composite database online (wxis) for them to search…hence
the over 142000 records.</span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;">I had done the
search in Winisis before to verify and confirm the number of
records that ‘bool’ would find.</span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;">Anyway I did
what you suggested (see snapshot) but the records are still
not marked or deleted when I open the database in Winisis to
verify if they have gone or are logically deleted.</span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;"> </span></div>
<div class="yiv6616769979MsoNormal"><img id="yiv6616769979Picture_x0020_1" src="cid:tXgcWGe0yoDBx0X1J2Bw" height="334" width="361"><img id="yiv6616769979Picture_x0020_2" src="cid:AZ9dUn1oKY8wFXXa2Bec" height="336" width="366"><span style="color:#1F497D;">See <b>PIOJ</b> in
the first field. This is after the mx operation. These PIOJ
records are scattered in the db.</span></div>
<div class="yiv6616769979MsoNormal"><span style="color:#1F497D;"> </span></div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in;">
<div class="yiv6616769979MsoNormal"><b><span style="font-size:10.0pt;color:windowtext;" lang="EN-US">From:</span></b><span style="font-size:10.0pt;color:windowtext;" lang="EN-US"> isis-users
[<a rel="nofollow" class="yiv6616769979moz-txt-link-freetext" ymailto="mailto:isis-users-bounces+nlj_bmheron=hotmail.com@iccisis.org" target="_blank" href="mailto:isis-users-bounces+nlj_bmheron=hotmail.com@iccisis.org">mailto:isis-users-bounces+nlj_bmheron=hotmail.com@iccisis.org</a>]
<b>On Behalf Of </b>spinaker<br>
<b>Sent:</b> Monday, October 12, 2015 4:25 PM<br>
<b>To:</b> <a rel="nofollow" class="yiv6616769979moz-txt-link-abbreviated" ymailto="mailto:isis-users@iccisis.org" target="_blank" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
<b>Subject:</b> Re: [Isis-users] MX utility</span></div>
</div>
</div>
<div class="yiv6616769979MsoNormal"> </div>
<div>
<div class="yiv6616769979MsoNormal">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=""><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ó:</div>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt;">
<div class="yiv6616769979MsoNormal"><br>
</div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">Hello
all,</span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">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></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">I
tried the mx utility.</span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">
Mx dbase bool=pioj proc=’d.’</span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">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></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">Shed
some light please. Thanks</span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;">Bridgette</span></div>
<div class="yiv6616769979MsoNormal"><span style="font-size:10.0pt;"> </span></div>
<div class="yiv6616769979MsoNormal"><br>
<br>
<br>
</div>
<pre>_______________________________________________</pre>
<pre>isis-users mailing list</pre>
<pre><a rel="nofollow" ymailto="mailto:isis-users@iccisis.org" target="_blank" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a></pre>
<pre>To manage your own subscription options go to: <a rel="nofollow" target="_blank" href="http://lists.iccisis.org/listinfo/isis-users">http://lists.iccisis.org/listinfo/isis-users</a></pre>
<pre>Or contact Henk Rutten: <a rel="nofollow" ymailto="mailto:hlrutten@xs4all.nl" target="_blank" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a></pre>
</blockquote>
<div class="yiv6616769979MsoNormal"><br>
<br>
<br>
</div>
<pre>-- </pre>
<pre> .^. .^.</pre>
<pre> ( ) ( )</pre>
<pre> === ===</pre>
<pre> =[=]================================[=]=</pre>
<pre> | | Ernesto Spinak | |</pre>
<pre> | | <a rel="nofollow" ymailto="mailto:spinaker@adinet.com.uy" target="_blank" href="mailto:spinaker@adinet.com.uy">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>
</blockquote>
<br>
<br>
<pre class="yiv6616769979moz-signature">--
.^. .^.
( ) ( )
=== ===
=[=]================================[=]=
| | Ernesto Spinak | |
| | <a rel="nofollow" class="yiv6616769979moz-txt-link-abbreviated" ymailto="mailto:spinaker@adinet.com.uy" target="_blank" href="mailto:spinaker@adinet.com.uy">spinaker@adinet.com.uy</a> | |
| | Montevideo, Uruguay | |
| | tel/fax (598) 2622-3352 | |
| | celular (598) 99612238 | |
=[=]================================[=]=
=== ===
( ) ( )
V V </pre>
</div>
</div><br>_______________________________________________<br>isis-users mailing list<br><a ymailto="mailto:isis-users@iccisis.org" href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>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><br>Or contact Henk Rutten: <a ymailto="mailto:hlrutten@xs4all.nl" href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a><br><br><br></div> </div> </div> </div></div></body></html>