<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">If you want e.g. to put the MFN, which is by definition a sequential number, into the field 1 as CN, in a database with name 'mydb', you could use the following command :
<br>
<br>
mx mydb "proc='d1','<1>',mfn(0),'</1>'" copy=mydb now -all<br>
<br>
After running this process, which deletes the current values of v1 (the CN) and then replaces it by the MFN, all your MFN's will have the MFN-number in field 1. The MFN's later on can still change (e.g. after compacting your DB) but the values in the field
1 will remain. <br>
Beware : if you already created copies and loanobjects, you will have to recreate them.<br>
There are some interesting new utilities in v1.4 to do this.<br>
<div><br>
<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-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF318550"><font size="2" color="#000000" face="Tahoma"><b>From:</b> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of bhowa tg [bhowatg@gmail.com]<br>
<b>Sent:</b> Tuesday, November 18, 2014 1:28 PM<br>
<b>To:</b> ISIS Users List<br>
<b>Subject:</b> [Isis-users] MX Tools-Reset CN_<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">Colleagues,<br>
<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">i have a database with 3000+ records, via utilities its timing out if try to resent CN_. i tried doing it in batches and only processing 20 records at a time.<br>
<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">an MX command i can use to reset my 3000+ CN_???<br>
<br>
</div>
<div class="gmail_default" style="font-family:comic sans ms,sans-serif">good day<br>
<br>
tg<br clear="all">
</div>
<br>
-- <br>
<div class="gmail_signature">
<div dir="ltr"><br>
<span style="font-family:comic sans ms,sans-serif">bhowa tg<br>
Infoprenuer, abcdZim.org<br>
<a href="mailto:bhowatg@gmail.com" target="_blank">bhowatg@gmail.com</a> IM & skypeID: bhowatg<br>
blog: <a href="http://bhowatg.blogspot.com" target="_blank">http://bhowatg.blogspot.com</a><br>
<a href="http://facebook.com/groups/abcdzim/" target="_blank">http://facebook.com/groups/abcdzim/</a>;
<a href="http://twitter.com/bhowatg" target="_blank">http://twitter.com/bhowatg</a><br>
<a href="http://www.abcdZim.co.cc" target="_blank">www.abcdZim.co.cc</a><br>
</span><br>
<br>
<span style="font-family:comic sans ms,sans-serif">"there are two equally dangerous extremes-<br>
to shut reason out and to let nothing else in"<br>
Pascal, 1670</span><br>
<br>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>