System catalogue

Posted in 2000

Topics: Triggers, Constraints & Referential Integrity

Maxim R. Ahmetov — Tue, 01 Feb 2000 15:13:26 +0500 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Maxim R. Ahmetov

Stefan Weideneder — Tue, 01 Feb 2000 14:27:27 +0100 — source: Informix-list mailing list archive (1991-1998)

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 -----

↪ replying to Stefan Weideneder

Avi Abrami — Tue, 01 Feb 2000 16:17:56 +0200 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Avi Abrami

Maxim R. Ahmetov — Wed, 02 Feb 2000 15:15:51 +0500 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Maxim R. Ahmetov

Rob Wilson — Wed, 02 Feb 2000 16:19:46 GMT — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Rob Wilson

Rick — Thu, 03 Feb 2000 11:25:15 -0800 — source: Informix-list mailing list archive (1991-1998)

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!