Re: 'create database' with ISQL + ONLINE
olhe4000@mailszrz.zrz.tu-berlin.de (Olaf Hendel) writes:
>
>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.
When you use the menu to create a database, you can't supply the dbspace.
This also doesn't work in dbaccess.
The only way there is is to use sql to create the database. The
SQL-statement is exactly as you wrote above and then the database will be
created in the given dbspace.
Good luck,
Raymond
---------------------------------------------------------------------------
Raymond Wooninck | Internet : raymond@zappelin.wlink.nl
's-Hertogenbosch, The Netherlands| Compu$erve : 73361,2673
---------------------------------------------------------------------------