Re: Violations and Filtering mode

Sadagopan, Sathish wrote: > > Hi, > I was trying to catch the rows which disobeyed a constraint ,So I started > violations on the table , set constraints disabled , did the data > insert/update then enabled the constraints , looked into *_vio,*_dia tables. > Question: What is the filtering mode used for ? How does it help ? > TIA > Sathish It is a mechanism for the database to tell you what it knows about the rows that violate constraints. Without it you have to do the work yourself. It's great for loading data or adding constraints, saves masses of work. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/