<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Please first explain what is this CPF ? A field in your records ? Excuse my ignorance on this.<br>
<div>And I suppose I should read your last sentence '<font size="2" face="sans-serif">If the existing CPF does not make inclusion of the registry' as : 'if the CPF does not exist, include the record' ?<br>
I think the logics of the task you describe here now is slightly different from the one you presented first but no problem.<br>
I would first create a database from your input.txt file anyway : with two databases in ISIS-format a lot more is possible, e.g. use a JOIN= parameter, index on a field and if a given term (a number or maybe your CPF ?) is not present in the index perform a
process etc.<br>
<br>
</font>
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF156078" style="direction: ltr;"><font color="#000000" size="2" face="Tahoma"><b>From:</b> Jacqueline Pawlowski Oliveira [jackie@bu.ufmg.br]<br>
<b>Sent:</b> Wednesday, April 12, 2017 10:38 PM<br>
<b>To:</b> De Smet Egbert<br>
<b>Cc:</b> isis-users@iccisis.org<br>
<b>Subject:</b> RE: [Isis-users] Criar novo registro na Base usando MX<br>
</font><br>
</div>
<div></div>
<div>
<p><font size="2" face="sans-serif">Hello Egbert. thanks for your answer.</font><br>
<br>
<br>
<font size="2" face="sans-serif">I'm not using winisis because I'm doing an integration with another system that will read a data file, compare it with the CPF and if this CPF does not exist in my isis database it will include data from an file input.txt. But
for this I need to compare whether or not the CPF exists on the isis database. If the existing CPF does not make inclusion of the registry.</font><br>
<br>
<font size="2" face="sans-serif">How would the proc command in this case?</font><br>
<br>
<font size="2" face="sans-serif">Thanks</font><br>
<font size="2" face="sans-serif">____________________________________________<br>
Jacqueline Pawlowski Oliveira<br>
Divisão de Tratamento e Tecnologia da Informação<br>
Biblioteca Universitária/UFMG<br>
Tel: (031) 3409-4619</font><br>
</p>
<div id="cSec1"><a href="UrlBlockedError.aspx" target="_blank"><img alt="Mostrar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete" border="0"></a><a><font color="#424282" size="2" face="sans-serif">De
Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete</font></a></div>
<div id="xSec1"><a href="UrlBlockedError.aspx" target="_blank"><img alt="Ocultar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete" border="0"></a><a><font color="#424282" size="2" face="sans-serif">De
Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete</font></a><br>
<br>
<font color="#5F5F5F" size="1" face="sans-serif">De: </font><font size="1" face="sans-serif">De Smet Egbert <egbert.desmet@uantwerpen.be></font><br>
<font color="#5F5F5F" size="1" face="sans-serif">Para: </font><font size="1" face="sans-serif">Jacqueline Pawlowski Oliveira <jackie@bu.ufmg.br>, "isis-users@iccisis.org" <isis-users@iccisis.org></font><br>
<font color="#5F5F5F" size="1" face="sans-serif">Data: </font><font size="1" face="sans-serif">12/04/2017 05:23</font><br>
<font color="#5F5F5F" size="1" face="sans-serif">Assunto: </font><font size="1" face="sans-serif">RE: [Isis-users] Criar novo registro na Base usando MX</font><br>
<hr style="color:#8091A5" size="2" align="left" noshade="" width="100%">
<br>
<br>
<br>
<font size="2" face="Tahoma">Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete the records, in a separate database, which don't have the value '12345' as CPF and then import (append) that resulting set of records
in your database.<br>
</font><br>
<font size="2" face="Tahoma">Egbert de Smet<br>
Universiteit Antwerpen</font><br>
<hr size="2" align="left" width="100%">
<br>
<font size="2" face="Tahoma"><b>From:</b></font><font size="2" face="Tahoma"> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of Jacqueline Pawlowski Oliveira [jackie@bu.ufmg.br]</font><font size="2" face="Tahoma"><b><br>
Sent:</b></font><font size="2" face="Tahoma"> Wednesday, April 12, 2017 12:25 AM</font><font size="2" face="Tahoma"><b><br>
To:</b></font><font size="2" face="Tahoma"> isis-users@iccisis.org</font><font size="2" face="Tahoma"><b><br>
Subject:</b></font><font size="2" face="Tahoma"> [Isis-users] Criar novo registro na Base usando MX</font><font size="3" face="Roman"><br>
</font><br>
<font size="2" face="sans-serif">Boa Tarde,</font><font size="3" face="Roman"><br>
<br>
</font><font size="2" face="sans-serif"><br>
Preciso inserir dados em uma base de dados ISIS, acrescentando novos registros. (update). Mas tenho que fazer uma validação antes. Por exemplo: Se existir o dado de CPF= 12345 então não faça nada, se não, inserir um novo MFN com dados de campo 100, 245 e
300. Qual a melhor forma de fazer? Posso fazer usando o MX?</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Obrigada pela ajuda.</font><font size="3" face="Roman"><br>
<br>
</font><font size="2" face="sans-serif"><br>
_______________<br>
English</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
I need to insert data into an ISIS database, adding new records. (Update). But I have to do a validation before. For example: If the CPF data = 12345 then do nothing, else insert a new MFN with field v100(data), v245(data) and v300(data) . What is the best
way to do it? Can I do it using MX?</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Thanks for help.</font><font size="3" face="Roman"><br>
</font><font size="2" face="sans-serif"><br>
Sorry my English :)<br>
____________________________________________<br>
Jacqueline Pawlowski Oliveira<br>
Divisão de Tratamento e Tecnologia da Informação<br>
Biblioteca Universitária/UFMG<br>
Tel: (031) 3409-4619</font></div>
<br>
</div>
</div>
</div>
</body>
</html>