System catalogue
Maxim R. Ahmetov asked how to create a trigger on informix.systables in ODS 7.3, for a database synchronization system. Stefan Weideneder answered that triggers cannot be defined on system tables. Avi Abrami asked why he wanted one. Rob Wilson suggested Cloudscape and Rick suggested HDR as replication alternatives. No workaround for the trigger itself was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max
Maxim R. Ahmetov wrote: > > Hello! > > Can anybody explain me how I can create trigger on "informix".systables? > > (The server I deal with is Informix Online Dynamic Server 7.3.) > > Max Hi, .......... You cannot define triggers for system tables. Bye Stefan Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----
Stefan Weideneder wrote: > Maxim R. Ahmetov wrote: > > > > Hello! > > > > Can anybody explain me how I can create trigger on "informix".systables? > > > > (The server I deal with is Informix Online Dynamic Server 7.3.) > > > > Max > > Hi, > > .......... You cannot > define triggers for system tables. > > Bye > > Stefan > > Phone: +49 89/3565478-2 --------------- > --- Fax: +49 89/3565478-3 ------------- > ------ mailto:/stefan@weideneder.de --- > -------- http://www.weideneder.de ----- But of-course the real question is - why would you want to create a trigger on 'informix'.systables? Please enlighten us! -- /\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd. /__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL / \\ \\/ | Phone:+972-3-5384717 Fax:+972-3-5335877 eMail:avia@telegate.co.il
Avi Abrami wrote: > Stefan Weideneder wrote: > > > Maxim R. Ahmetov wrote: > > > > > > Hello! > > > > > > Can anybody explain me how I can create trigger on "informix".systables? > > > > > > (The server I deal with is Informix Online Dynamic Server 7.3.) > > > > > > Max > > > > Hi, > > > > .......... You cannot > > define triggers for system tables. > > > > Bye > > > > Stefan > > > > Phone: +49 89/3565478-2 --------------- > > --- Fax: +49 89/3565478-3 ------------- > > ------ mailto:/stefan@weideneder.de --- > > -------- http://www.weideneder.de ----- > > But of-course the real question is - why would you want > to create a trigger on 'informix'.systables? > Please enlighten us! > > -- > /\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd. > /__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL > / \\ \\/ | Phone:+972-3-5384717 Fax:+972-3-5335877 eMail:avia@telegate.co.il Hi, I have been developing a synchronization system. The system being developed implies synchronization of database structures and synchronization of data from several tables. So, in order to relate a modification of data in a table to an alteration of that table I would like to spot when the alteration has happened. Of course, I can develop the system without creating triggers on system tables but in this case, more coding is required. Bye Max
Maxim R. Ahmetov (ahmetov@centrobank.e-burg.ru) wrote: : Hi, : I have been developing a synchronization system. The system being developed : implies synchronization of database structures and synchronization of data from : several tables. So, in order to relate a modification of data in a table to an : alteration of that table I would like to spot when the alteration has happened. : Of course, I can develop the system without creating triggers on system tables but : in this case, more coding is required. : Bye : Max Have you looked at Cloudscape at all? It replicates data and schema changes. -- Rob Wilson rwilson@ntsource.com
Sounds like HDR to me. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!