Re: problem with drop constraints

From: nayan jain <nayan.jain@tatainfotech.com> > >This gives me a proper command to run, but it doesnt run by itself. >i get it on the dbaccess prompt and then i have to copy paste that to >another sql and run it. > >Means, some manual intervention has to be there. > >we have to run this script a 'n' number of times. >sowant to remove the manual intervention. > >but the restriction, it has to be done thru sql in dbaccess only. > >so there is any other way for that ? Sheesh. Would you like me to come and run it for you? :0) OUTPUT TO PIPE "dbaccess dbname" SELECT "alter table sam_user( drop constraint " || constrname || ");" from sysconstraints c, systables t, sysindexes i where c.tabid = t.tabid and tabname = "sam_user" and constrtype = "R" and i.tabid = t.tabid and idxtype = "D" and part1 = 5 http://www.informix.com/answers/ ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com