Re: 'create database' with ISQL + ONLINE

}From: olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel) }Subject: 'create database' with ISQL + ONLINE }Date: 10 Dec 1993 12:09:18 GMT }X-Informix-List-Id: <news.5053> } }Hi, } }we changed from Informix SE to Informix Online 5.0 with all this }developing tools like r4gl, isql, etc. }My question is: } }When you create a database from the isql menu, is there any possibility }to change the default dbspace? (I know, you can create the db with }a sql-statement like "create db in dbsace") But if you use the isql-menu }all databases will be created in the rootdb. I found no hints in the }manuals, maybe somone knows a solution! } }The problem is, that we have some novice users, which will prefer the }isql-frontend. So our rootspace will be filled very rapidly, I'm afraid. } }Thanks, } }Olaf Hendel }TU-Berlin, Germany Using ISQL, you cannot specify the default dbspace. I believe that if you have multiple dbspaces, then DBACCESS gives you the option of naming the dbspace -- the manual isn't explicit on the point (check out DBACCES User Manual, p 2-4, 2-11, 2-12, 4-6 to 4-8), and I only have a single dbspace in my OnLine system so I can't check it for you. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>

On Fri, 10 Dec 1993, Jonathan Leffler wrote: > > }From: olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel) > }Subject: 'create database' with ISQL + ONLINE > }Date: 10 Dec 1993 12:09:18 GMT > }X-Informix-List-Id: <news.5053> > } > }Hi, > } > }When you create a database from the isql menu, is there any possibility > }to change the default dbspace? (I know, you can create the db with > }a sql-statement like "create db in dbsace") But if you use the isql-menu > }all databases will be created in the rootdb. I found no hints in the > }manuals, maybe somone knows a solution! > } ........ > }Olaf Hendel > }TU-Berlin, Germany > > Using ISQL, you cannot specify the default dbspace. > > I believe that if you have multiple dbspaces, then DBACCESS gives you the > option of naming the dbspace -- the manual isn't explicit on the point > (check out DBACCES User Manual, p 2-4, 2-11, 2-12, 4-6 to 4-8), and > I only have a single dbspace in my OnLine system so I can't check it for > you. > > Yours, In DBaccess, as far I know,the only way to ensure that a database is created in the correct dbspace, is with the "Query-Language" menu option and the SQL statement "CREATE database <dbname> IN <dbspace> ...." Users who create a data base with the "Create" option from within the Database menu in DBaccess create their database in the root dbspace. It would be nice if there was some possibility to: (1) prevent users from creating a database in the root dbspace and more (2) ensure that certain users or group of users can only create databases in specific dbspaces. ------------------------------------------------------------------------------- Luc Verschraegen Phone: +32-(0)9-2644732 E-mail: Luc.Verschraegen@rug.ac.be Fax: +32-(0)9-2644994 -------------------------------------------------------------------------------