<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Renate,</p>
<p><br>
</p>
<p>Try this:</p>
<p><br>
</p>
<p>mx dbn proc="if v20*0.3='CA' then 'D.' fi" copy=test now -all</p>
<p><br>
</p>
<p>or put your proc in a file that contains the command:</p>
<p><br>
</p>
<p> </p>
<p> if v20*0.3='CA' then 'D.' fi<br>
</p>
<p><br>
</p>
<p>so that you can write:</p>
<p><br>
</p>
<p>mx dbn proc=@del.prc copy=test now -all</p>
<p><br>
</p>
<p><br>
</p>
<p>Piet de Keyser</p>
<p>UC Leuven, Belgium<br>
</p>
<p><br>
</p>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>Van:</b> isis-users <isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org> namens Renate Morgenstern <rmorgenstern@iway.na><br>
<b>Verzonden:</b> dinsdag 14 maart 2017 20:51<br>
<b>Aan:</b> isis-users@iccisis.org<br>
<b>Onderwerp:</b> [Isis-users] Delete records with MX</font>
<div> </div>
</div>
<div>Good day,<br>
<br>
I want to delete a large number of records in a database, depending on the contents of a field,<br>
What is the correct command with mx to achieve this.<br>
mx dbn proc=if v20*0.3='CA' then 'D.' fi copy=test now -all.<br>
I get an error with this command 'fatal: f.<br>
Thanks for any help.<br>
<br>
Renate </div>
</div>
</body>
</html>