<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">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>Renate</p>
<p><br>
</p>
<p>You can update or delte records in the same database of the source data, but in your example your records come fomr DBN and you are deleting on a non-existente TEST database</p>
<p>Therfore the command should be</p>
<p><br>
</p>
<p>mx dbn "proc=if v20*30.3='CA' then 'd.' fi" copy=dbn now -all tell=1000</p>
<p><br>
</p>
<p>take note of the quotes to encluse the proc expression</p>
<p><br>
</p>
<p>Regards</p>
<p>Ernesto Spinak<br>
</p>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="width: 98%; display: inline-block;">
<div id="divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size: 11pt;"><b>De:</b> isis-users <isis-users-bounces+ernesto_luis_96=hotmail.com@iccisis.org> en nombre de Renate Morgenstern <rmorgenstern@iway.na><br>
<b>Enviado:</b> martes, 14 de marzo de 2017 16:51<br>
<b>Para:</b> isis-users@iccisis.org<br>
<b>Asunto:</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>
</div>
</body>
</html>