Sybase User Asks: Creating Database
Jack A, a Sybase user, asked how to create a database in Informix since the administrator's guide did not say. Jay Aymond gave CREATE DATABASE db_name. Art S. Kagel gave the syntax with optional IN dbspace and WITH BUFFERED LOG, pointing to the Guide to SQL Syntax, and Madison Pruet pointed to the Informix Guide to SQL. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
How do we create databases in informix ? Its amazing the whole Systems administrator guide has nothing on it. They talk about how datbase creation affects space usage and SMI tables but dont say a word on creating the database. I know we can create a database using on monitor but isnt there any Sql to do this operation. Thanks
create database db_name
"Jack A" <InformixMail@yahoo.com> wrote in message
news:ce0e3c22.0308041219.6fb8a87@posting.google.com...
> How do we create databases in informix ? Its amazing the whole Systems
> administrator guide has nothing on it. They talk about how datbase
> creation affects space usage and SMI tables but dont say a word on
> creating the database. I know we can create a database using on
> monitor but isnt there any Sql to do this operation.
>
> Thanks
On Mon, 04 Aug 2003 16:19:41 -0400, Jack A wrote:
It's documented in the Guide to SQL Syntax and Guide to SQL Reference:
CREATE DATABASE databasename {IN dbspacename} {WITH {BUFFERED} LOG};
Art S. Kagel
> How do we create databases in informix ? Its amazing the whole Systems
> administrator guide has nothing on it. They talk about how datbase
> creation affects space usage and SMI tables but dont say a word on
> creating the database. I know we can create a database using on monitor
> but isnt there any Sql to do this operation.
>
> Thanks
Jack, DML and DDL statements are documented in the document "Informix Guide to SQL" M.Pruet "Jack A" <InformixMail@yahoo.com> wrote in message news:ce0e3c22.0308041219.6fb8a87@posting.google.com... > How do we create databases in informix ? Its amazing the whole Systems > administrator guide has nothing on it. They talk about how datbase > creation affects space usage and SMI tables but dont say a word on > creating the database. I know we can create a database using on > monitor but isnt there any Sql to do this operation. > > Thanks