The system is already running on a relational database. Its running tbred solution 4 for UNIX. It’s a very old system that lacks a lot of the flexibility of newer databases such as oracle. However the system highly customizable so its not worth the effort to upgrade. I have been using Perl to "build in" some functionality that it is lacking.
-----Original Message----- From: Kipp, James [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:42 AM To: 'NYIMI Jose (BMB)'; [EMAIL PROTECTED]; Perl Subject: RE: Finding Duplicates. > > > > So you are looking for duplicates on any field? Wouldn't you > > just be looking for a dup on the Name? Shouldn't the CustCode > > field be unique? > > Has your company thought about importing these files into a > > relational database. Would be much faster and easier. > > This will not solve the problem of Paul, since it's possible > by accident to insert the "same customer" > with different customer code in the database. > The problem here if I well understood, is to have a tool that > will check such duplication. > > José. Hi José I realize this does not solve the immediate problem. I was suggesting the use of a database for future use. I would like to help solve this with perl, but wanted to get some more information from Paul first. btw, a DB like Oracle can be used to prevent such duplications. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
