Re: Informix DSA : Default storage database location ........

On Thu, 7 May 1998 11:25:03 +0200, JEAN-PHILIPPE_BATTU@Non-HP-France-om3.om.hp.com wrote: > >Hello Techies ! > >I am running Online 7.23 on HP/UX 10.xx. > >When I create a table in a database, it is created by default in the rootdbs That's because the database itself was originally created in rootdbs. You shouldn't ever place database (or tables) there. All tables are by default place where the database was originally created. >If I specify a location, I can change the location dbspace > >Do you know if I could specify on default dbspace into an environnement variable >like DEFAULTDBSPACE, for example. No, there is no such option. You can however export your database with dbexport, drop it and import it to another dbspace with dbimport. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)