[Isis-users] Delete records with MX

[Ernesto Spinak]

Renate


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

Therfore the command should be


mx dbn "proc=if v20*30.3='CA' then 'd.' fi"  copy=dbn now -all tell=1000


take note of the quotes to encluse the proc expression


Regards

Ernesto Spinak


________________________________
De: isis-users <isis-users-bounces+ernesto_luis_96=hotmail.com at iccisis.org> en nombre de Renate Morgenstern <rmorgenstern at iway.na>
Enviado: martes, 14 de marzo de 2017 16:51
Para: isis-users at iccisis.org
Asunto: [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/3f328e71/attachment.html>