Re: Automation and dbaccess

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