[Isis-users] Global delete

[spinaker]

Dear Peter

Piet solution is correct, I'd like to explain his comment

if you give a proc  'd.'  you are deleting the record, but if you give  
'd*' you are deleting the fields but not the record
therefore if you create a new master file, you could save void records 
but not phyisical deleted record
but you can do a 'd.' if you copy the base onself, like

mx db  test  "proc='if ... then   'd.' fi"  copy=test

regards
Ernesto Spinak

El 27/02/2013 13:28, Piet De Keyser escribió:
>
> Dear Peter,
>
> I would do this using a proc in MX:
>
> This proc  (let's call it  del.prc) could be
>
> If v852^a:'XYZ' then 'd*' fi
>
> (Don't use 'd.' here; it will give you an error.)
>
> The command can be something like this (where db stands for the name 
> of your database):
>
> Mx db  create=test proc=@del.prc <mailto:proc=@del.prc> now --all
>
> Piet de Keyser
>
> Leuven University College, Belgium
>
> *Van:*isis-users-bounces at iccisis.org 
> [mailto:isis-users-bounces at iccisis.org] *Namens *Hessels, Peter
> *Verzonden:* woensdag 27 februari 2013 15:13
> *Aan:* isis-users at iccisis.org
> *Onderwerp:* [Isis-users] Global delete
>
> Dear all,
>
> I want to delete some records from my database (all records that have 
> the value XYZ in field v852^a). I would call it a global delete.
>
> How can this be done?
>
> (from the documentation I can read I can do global changes, with 
> either ABCd or mx-utility; but no option for a global delete).
>
> Any suggestions?
>
> Kind regards,
>
> Peter
>
>
>
> _______________________________________________
> isis-users mailing list
> isis-users at iccisis.org
> To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
> Or contact Henk Rutten: hlrutten at xs4all.nl


-- 
   .^.                                .^.
   ( )                                ( )
   ===                                ===
  =[=]================================[=]=
   | |  Ernesto Spinak                | |
   | |  spinaker at adinet.com.uy        | |
   | |  Montevideo, Uruguay           | |
   | |  tel/fax  (598) 2622-3352      | |
   | |  celular  (598) 99612238      | |
  =[=]================================[=]=
   ===                                ===
   ( )                                ( )
    V                                  V

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20130227/0b53b050/attachment.html>