[Isis-users] Delete records with MX

[Piet De Keyser]

Renate,


Try this:


mx dbn proc="if v20*0.3='CA' then 'D.' fi" copy=test now -all


or put your proc in a file that contains the command:




        if v20*0.3='CA' then 'D.' fi


so that you can write:


mx dbn proc=@del.prc copy=test now -all



Piet de Keyser

UC Leuven, Belgium


________________________________
Van: isis-users <isis-users-bounces+piet.dekeyser=ucll.be at iccisis.org> namens Renate Morgenstern <rmorgenstern at iway.na>
Verzonden: dinsdag 14 maart 2017 20:51
Aan: isis-users at iccisis.org
Onderwerp: [Isis-users] Delete records with MX

Good day,

I want to delete a large number of records in a database, depending on the contents of a field,
What is the correct command with mx to achieve this.
mx dbn proc=if v20*0.3='CA' then 'D.' fi copy=test now -all.
I get an error with this command  'fatal: f.
Thanks for any help.

Renate
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20170314/ca2c41da/attachment.html>