Progress
Language Reference
CREATE DATABASE Statement
Creates a new Progress database.
SYNTAX
new-database
A CHARACTER expression that returns the full or relative pathname of the database you want to create. If the database already exists, a new database is not created unless you specify REPLACE.
FROM old-database
A CHARACTER expression that returns the name of the database whose schema and data you want to copy to the new database. The value of old-database can be a full or relative pathname or one of the special strings "EMPTY", "DEMO", or "SPORTS". If you omit this option, Progress creates an empty database.
REPLACE
If you specify this option and a database already exists with the name specified by new-database, then the existing database is deleted and replaced with the new database. If you do not specify REPLACE, you receive an error occurs if the database exists.
NO-ERROR
If you specify this option and the CREATE DATABASE statement fails, the error condition is not raised.
EXAMPLEThis procedure prompts for the name of a database to connect. If the database does not exist, the user can create it.
NOTES
SEE ALSO
ALIAS Function, CONNECT Statement, CONNECTED Function, CREATE ALIAS Statement, DATASERVERS Function, DBCODEPAGE Function, DBCOLLATION Function, DBRESTRICTIONS Function, DBTYPE Function, DELETE ALIAS Statement, DISCONNECT Statement, ERROR-STATUS System Handle, FRAME-DB Function, LDBNAME Function, NUM-DBS Function, PDBNAME Function, SDBNAME Function
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |