Re: Informix DSA : Default storage database location ........
JEAN-PHILIPPE_BATTU@Non-HP-France-om3.om.hp.com wrote:
<snip>
: When I create a table in a database, it is created by default in the rootdbs
: 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
try it like this:
CREATE DATABASE blah-blah in your_dbspace with buffered log;
or however you want to log. All tables in blah-blah will be in your_dbspace
unless you specify otherwise in the CREATE TABLE.
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998
from Prentice Hall/Informix Press. If you have debugging tips, tools, or
ideas to share, please send me some e-mail.
---------------------------------------------------------------------------