RE: Replicate some records of an Informix 7.2 database
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BD2D5A.941829C0 Content-Type: text/plain Just so people won't get confused: CDR is the _OLD_ name for "Enterprise Replication" or ER. Our instructor at the 7.2 Extended Features class (most of which is devoted to ER) told us that the product was called CDR all during development, QA, etc., and at the last minute before it went out the door, it was decided that it would be called Enterprise Replication. BTW, it appears to be a great product. We are going to start using it for our "business resumption" servers. ============================= Paul Mosser, Open Systems DBA Wells Fargo Bank Tempe, Arizona, USA mosserp@wellsfargo.com > ---------- > From: David Williams[SMTP:djw@smooth1.demon.co.uk] > Reply To: David Williams > Sent: Monday, January 26, 1998 12:47 PM > To: informix-list@rmy.emory.edu > Subject: Re: Replicate some records of an Informix 7.2 database > > In article <6ai76c$enf@cssun.mathcs.emory.edu>, John.Hagan@alltel.com > writes > > Would a trigger do the trick??? > > > Look into CDR. This can work but does take some setting up. > > > > >______________________________ Reply Separator > _________________________________ > >Subject: Replicate some records of an Informix 7.2 database > >Author: Stephane Galet <stephane.galet@sema.fr> at INTERNET > >Date: 1/26/98 5:21 AM > > > > > >I'm trying to replicate a database on Informix 7.2. > >I would like to select a subset of the records as in a Where clause. > >For example, I have a Status row indicating for each record if it > should > >be replicated or not. > >Is there an Informix tool that performs this function ? > > > >Thanks for your help. > > > >Stephane. > > > >-------------------==== Posted via Deja News > ====----------------------- > > http://www.dejanews.com/ Search, Read, Post to Usenet > > -- > David Williams > > Maintainer of the Informix FAQ > Primary site (Beta Version) http://www.smooth1.demon.co.uk > Official site > http://www.iiug.org/techinfo/faq/faq_top.html > > I see you standin', Standin' on your own, It's such a lonely place for > you, For > you to be If you need a shoulder, Or if you need a friend, I'll be > here > standing, Until the bitter end... > So don't chastise me Or think I, I mean you harm... > All I ever wanted Was for you To know that I care > ------ =_NextPart_000_01BD2D5A.941829C0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+Ih4PAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQA3AAAAUkU6IFJlcGxpY2F0ZSBzb21lIHJlY29yZHMgb2Yg YW4gSW5mb3JtaXggNy4yIGRhdGFiYXNlAMwSAQmAAQAhAAAARDcyNDkwREI4NDk5RDExMUFCNkYw MDAwODM3NjEyQkEAAgcBIIADAA4AAADOBwEAHgAIACcAGgAFAEIBAQWAAwAOAAAAzgcBAB4ACAAu ACEABQBQAQENgAQAAgAAAAIAAgABA5AGAOwKAAAdAAAAAwAuAAAAAABAADkAIJWyPZYtvQEeAHAA AQAAADMAAABSZXBsaWNhdGUgc29tZSByZWNvcmRzIG9mIGFuIEluZm9ybWl4IDcuMiBkYXRhYmFz ZQAAAgFxAAEAAAAbAAAAAb0qxZ9l2L49e5ahEdGTdwAA+EWyCgCz7W8hAAIBCRABAAAAaQcAAGUH AACNDQAATFpGdZc/kj0DAAoAcmNwZzEyNf4yAP8CBgKkA+QF6wKDAFATA1QCAGNoCsBzZXR+MgYA BsMCgw5QA9QCAHDYcnExEK8CADMERhQ1dwhVB7ICgzQDxgcTAoB9twqACM8J2TsZnw4wNQKAlwqB DnELYG4OEDAzFcBCaAWwemRvYwAAKu0SVSACkR2gbB3VCvsVwYUL8mMAQCBKdXMFQEBzbyBwZW8L UGVUIHcCICcFQGcSwCDZBaBuZiCQCYA6CoUKhRBDRFIgBAAgdGgBIVBfT0xEXyBummEHgCACEAXA IkUCMM8EkBRQBAAhUFJlC1AN4EhhdGkCICIgBbFF4FIuICBPCHAjsACA4HRydWN0BbEmQCPjpDcu EuBFeCVQbg5wcGQgRmUmQAhwB5FjmwtgBBEoBGAgoW9mIWCaaA3gaCOyDnB2byVQ1ylAJ+Am0Skr 4WwpQCCQ/yPhKCUUUARwJ8EhYCoQIgD/B0AhQClAI4IuQStgCHEcoDUrYmUZMHAHgAIwLCDMUUEw QBLAYy4wQABwrylAKCUqAQVAbQuAdSVQ3CBiDoAFsCFQaS3RMBH/JqAyMCPjHVAFsDBAMuIuAf0F gWkpIizjMuIIYCyBMnAXLiYlPyZDLiKsQlRXeTQjYXAhAB3yK/E2EWHfIcAZoCghLXUnAVc6QTKx /GdvL1Ir8SCgCsAFQCCQ3y9SMuEk4ghhJRBiPOIHkHMEICmxdW0FMCZjErByHy+wEqA4Fgr7E7Ix NyDOPUGPQkk/1VBhNdAF0PcqcD9RMEBPIQADoAawIKDEZW0EIERCQT/VO4B7LlAEIEYKwDvwOPAA cGu9P9VURSAhADBABxF6AiByYTBAVVNFhiphP1FwVkAzEEYhZkZyLgWgbY8/3x+sSnsmEDE4MALR 4GktMTQ0DrAM0E3TvwtZTVBKkANgNtAtwS1P969Kd06rDDBPdkYDYTpQ/udPdgyCRVBhdjTgO3AD EAMmECSgc1tTTVRQwDpkandAcwRgK6B4aDEuDnAEYDgABaAuuHVrXVCfUa0l4nlHYP5vUt9T71T4 V39RrQZgAjBPWf9bC0QQKRBheTBASk0AcHUKwFmwMjYwQDGIOTk4YgAyOjRBYPxQTVy/Ua1Z31rt C4Ak4VkyAHgtJhAgoEBnIHl+LlbBYaBn8C2gYu9dznX8YmpPsWUPWwsl4GsAJebfIVAg0CSxGaAF oWQEICqxfQORSWb1KINhAAGRKhBl8yKsTNYzNk53F8IgE05xP0+FbvA7oSZQKfAhUDw2IQtwNzZj JAnwZkD6YwQQdTgAAMAj8HTwZ/gSPmExb2g4AEhhZ60AcEAuQTbQbEo5dwUQ2zbQXKY+JxB5IVc1 wzpg+SegaWch0AXAHVAj43nxeGNrP3sweKZKdScQTL0z8GsnYSvxI4EnAFQq8PcuEgOgIXByfKA+ AAVAHVB7B5EBkGttpRKxJlAvYXXmcDgde9Y+X4GfgmpZZf8GYEqhJkAFsYJvhY54pmqX720vbj9v T3i1QTIwHRFrAJsGADbQcBKAPkAgRwdA7SHhPEUBjAMudvCMgVYgOUUgYS4DUHkQKCFJTuJUJuBO RVR4plSwNtBTi6EnEDEvYdAvYjE1dDoyFIBBYtaBB3imSfQnbXnheTwVGaCHxjpg/2/GJqCJXDgW knA1pSYQfvHfPFIvwE+yOmA+sGISsSqi3yPyiJYuAQuAOlFXJAAysZcp8SJRladGBbFleCSg/yEx MECWMBKAL7A6UYvQKYHtPnFvB+ALgGQmIy9hJOK/KXArEYiUI7AqwDLhcx0QvzXSeKY2EZNnKUAF sW4roP+VqCPTMrGJSifgBvAs1CEA3nJnAiPSI8EiQG4n0CZh/iB7V3kjeKZ9YEbRpIEFsfZ5PbIk AGyAB6W8i9an3/9400/4T/dCQkOwKnEpMVTQ8TpgRGVqOmAHwQQgQkL/qz9QO3kUaPdyVwBQNdBP ZhcecEbgKUBoAkBwOi/8L3ezEFahrWA+QK2wSjL+L7B/cuh5IwZgCsAScDBAuSXgYWQwQKySK+JV ErB9PkB0Iqyu8CMGW98i2U0/C3EBkD4xPZGYRIl3RkH6UXvmUAUQAMBhoQCQMkHsKEISwDpgVj+R JmEsQP+wb7F/sotWP1dAv19y6Hvm/k8OkA3gBzG99MZtw2/Ab0GymmlpdWcuBbBnri9PoSrwZvEv SeBxy1LuXyfggACyoG3IocOPxJ3/SnWWMBKwIVCnQTxynREhkL8wQJxRz8OUoqdDnNBum6H8dCcE ID6wKxE6YBkwPkD7WaELUWMkxKdBMECa8kp1+89SOgRJKsDPUj5AKTGXof+fI0RTJ1HVGwNQCJAp EJuhvicu8TYRmbNKdc+VZ0hR9wIwAxEj8mIy4DbRMJApEPYu2zBKdVMg4B1QIZIScf8goCWiJLHW gaRRRuCJYJuirweAA5HPUhKBbds4QS7x35YwL6F4IQBwK7JXLgGnBflk0SBroRAH4CzjljAmML8Z oHC/Tncf1cSdGMEA5cAAAAAeADFAAQAAABAAAABNT1NTRVJQNDM5OTFEQTcAAwAaQAAAAAAeADBA AQAAABAAAABNT1NTRVJQNDM5OTFEQTcAAwAZQAAAAAADADYAAAAAAB4AQhABAAAAJwAAADxmVXd5 cEJBUWhPejBFd3pxQHNtb290aDEuZGVtb24uY28udWs+AAADACYAAAAAAAIB+T8BAAAAZwAAAAAA AADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1XRUxMUyBGQVJHTyAmIENPLi9PVT1XRkIxL0NO PU5PTi1FWENIQU5HRSBSRUNJUElFTlRTL0NOPU1PU1NFUlA0Mzk5MURBNwAAHgD4PwEAAAANAAAA TW9zc2VyLCBQYXVsAAAAAB4AOEABAAAAEAAAAE1PU1NFUlA0Mzk5MURBNwACAfs/AQAAAGcAAAAA AAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VMTFMgRkFSR08gJiBDTy4vT1U9V0ZCMS9D Tj1OT04tRVhDSEFOR0UgUkVDSVBJRU5UUy9DTj1NT1NTRVJQNDM5OTFEQTcAAB4A+j8BAAAADQAA AE1vc3NlciwgUGF1bAAAAAAeADlAAQAAABAAAABNT1NTRVJQNDM5OTFEQTcAQAAHMDApIFWVLb0B QAAIMGzMHz+VLb0BHgA9AAEAAAAFAAAAUkU6IAAAAAAeAB0OAQAAADMAAABSZXBsaWNhdGUgc29t ZSByZWNvcmRzIG9mIGFuIEluZm9ybWl4IDcuMiBkYXRhYmFzZQAACwApAAAAAAALACMAAAAAAAMA BhBdmLobAwAHEHoGAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAASlVTVFNPUEVPUExFV09O VEdFVENPTkZVU0VEOkNEUklTVEhFT0xETkFNRUZPUiJFTlRFUlBSSVNFUkVQTElDQVRJT04iT1JF Uk9VUklOU1RSVUNUT1JBVFRIRTcyRVhURU5ERQAAAACkgQ== ------ =_NextPart_000_01BD2D5A.941829C0--