Re: Automation and dbaccess

Try onmode -ky;oninit This will shutdown the instance and force all sessions off. It will then restart. Chris Pope wrote: > > Now how do I kill the users? > > I need to find out the users of the database and kill them first and do this > all w/o manual intervention... > > "Bogdan Neagu" <bogdan.neagu@alcatel.com> wrote in message > news:3A2D5000.84ED5D00@alcatel.com... > > Finally I read the initial message. Sorry. > > > > I guess the syntax will be > > > > echo 'drop database <database>;'| dbaccess - - > > > > Chris Pope wrote: > > > > > That would drop a table..I presume. > > > > > > Would the sytax for dropping a database be > > > > > > echo 'drop database <database>;'| dbaccess <databasename> - > > > > > > ? > > > > > > "Bogdan Neagu" <bogdan.neagu@alcatel.com> wrote in message > > > news:3A2D32CF.EA37FEAE@alcatel.com... > > > > If you are on UNIX: > > > > > > > > echo 'drop table <tablename>;' | dbaccess <databasename> - > > > > > > > > HTH. > > > > > > > > Bogdan > > > > > > > > Chris Pope wrote: > > > > > > > > > Hi, I'm a neophyte Informix DBA. I'm trying to figure out how to > > > automate > > > > > the dropping of a database. I need to kill all the sessions and drop > the > > > > > database. How can I automate dbaccess to do this? > > > > > > > > > > Thanks. > > > > > > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > > > > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > > > > > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > > > > > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > > > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----