Sybase User Asks: Creating Database

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