Unix Technical Forum

Create database in specific dbspace

This is a discussion on Create database in specific dbspace within the Informix forums, part of the Database Server Software category; --> I want to create a new database in a specific DBspace so that all data is written into that ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 07:27 AM
Geezer From The Freezer
 
Posts: n/a
Default Create database in specific dbspace

I want to create a new database in a specific DBspace
so that all data is written into that dbspace in the
future....what is the command line options for this?
I want to keep it out of rootdbs
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 07:27 AM
Captain Pedantic
 
Posts: n/a
Default Re: Create database in specific dbspace

"Geezer From The Freezer" <Geezer@Freezer.com> wrote in message
news:41220F8C.93B94041@Freezer.com...
> I want to create a new database in a specific DBspace
> so that all data is written into that dbspace in the
> future....what is the command line options for this?
> I want to keep it out of rootdbs


Come on! This *really* is RTFM ...


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 07:27 AM
Gary Child
 
Posts: n/a
Default Re: Create database in specific dbspace

Geezer From The Freezer <Geezer@Freezer.com> wrote in message news:<41220F8C.93B94041@Freezer.com>...
> I want to create a new database in a specific DBspace
> so that all data is written into that dbspace in the
> future....what is the command line options for this?
> I want to keep it out of rootdbs


create database "database name" in "dbspace_name"
see Page 2-89 of Informix Guide to SQL:Syntax Vol 1
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:39 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com