Re: Cascade Delete Problem ...

But could not find out *Columns of child tables refering the parent key Try to get the info for constraints referenced in dbaccess SUNIL S. SINGH wrote: > -----------------------<sunil.singh@tatainfotech.com>------------------------- > . . > . . > . . > . . > . * > . TATA INFOTECH LTD. > . SEEPZ, > . Andheri (E), > SUNIL S. SINGH Mumbai - 400 096, > (Sr. Software Engineer) India. > ------------------------------------------------------------------------------ > > ---------- Forwarded message ---------- > Date: Sun, 20 Sep 1998 16:22:13 +0530 (IST) > From: "SUNIL S. SINGH" <sunil.singh@tatainfotech.com> > To: informix list <informix-list@iiug.org> > Subject: Cascade Delete Problem ... > > Hi ALL !! > > I have a table A (parent table) whose primary key is refered by other > tables B,C,D,E,F (child table) as foreign key. I want to delete some rows > form table A and all dependent row in child tables. > I could not find a DELETE SYNTAX like : > > DELETE CASCADE from parent_table (as in ORACLE) > > the only way I could figure out is to alter table and set DELETE RULE > as ON DELETE CASCADE.But I can;t do it due to some reason. > Another way is to find out all child table and write SQL script and > manually run it. > > Then I thought its better to write a ESQL/C routine which will accept name > of parent table and form Catalog Tables find out delendent table and > delete dependent row,but I got stuck in between b'cause. > I could find out > > *All child table from SYSREFERENCES and SYSTABLES > *Key of Parent table on which child depend > > But could not find out > *Columns of child tables refering the parent key > > Can anybody tell me where (In which Catalog Table) I can get this info ?? > > Is there any other way to DELETE CASCADE in Informix ?? > > I am using IDS 7.1 on Digital UNIX. > > Thanks. > Sunil SUNIL S. SINGH wrote: > -----------------------<sunil.singh@tatainfotech.com>------------------------- > . . > . . > . . > . . > . * > . TATA INFOTECH LTD. > . SEEPZ, > . Andheri (E), > SUNIL S. SINGH Mumbai - 400 096, > (Sr. Software Engineer) India. > ------------------------------------------------------------------------------ > > ---------- Forwarded message ---------- > Date: Sun, 20 Sep 1998 16:22:13 +0530 (IST) > From: "SUNIL S. SINGH" <sunil.singh@tatainfotech.com> > To: informix list <informix-list@iiug.org> > Subject: Cascade Delete Problem ... > > Hi ALL !! > > I have a table A (parent table) whose primary key is refered by other > tables B,C,D,E,F (child table) as foreign key. I want to delete some rows > form table A and all dependent row in child tables. > I could not find a DELETE SYNTAX like : > > DELETE CASCADE from parent_table (as in ORACLE) > > the only way I could figure out is to alter table and set DELETE RULE > as ON DELETE CASCADE.But I can;t do it due to some reason. > Another way is to find out all child table and write SQL script and > manually run it. > > Then I thought its better to write a ESQL/C routine which will accept name > of parent table and form Catalog Tables find out delendent table and > delete dependent row,but I got stuck in between b'cause. > I could find out > > *All child table from SYSREFERENCES and SYSTABLES > *Key of Parent table on which child depend > > But could not find out > *Columns of child tables refering the parent key > > Can anybody tell me where (In which Catalog Table) I can get this info ?? > > Is there any other way to DELETE CASCADE in Informix ?? > > I am using IDS 7.1 on Digital UNIX. > > Thanks. > Sunil