CREATE DATABASE (IBEBlock)

Please note that this function is deprecated. Please use ibec_CreateDatabase instead.


Syntax

CREATE DATABASE 'filespec' USER 'username' PASSWORD 'password'
   [CLIENTLIB 'libfile']
   [SQL_DIALECT dialect]
   [PAGE_SIZE int]
   [DEFAULT CHARACTER SET charset]
Argument Description
'filespec' A new database file specification; file naming conventions are platform-specific.
USER 'username' Checks the username against valid user name and password combinations in the security database (Server security ISC4.GDB / SECURITY.FDB) on the server where the database will reside.
PASSWORD 'password' Checks the password against valid user name and password combinations in the security database on the server where the database will reside; can be up to 8 characters.
CLIENTLIB 'libfile' Client library file name; default: gds32.dll.
SQL_DIALECT dialect The SQL Dialect for the new database, either 1, 2, or 3.
PAGE_SIZE int Size, in bytes, for database pages; int can be 1024 (default), 2048, 4096, or 8192.
DEFAULT CHARACTER SET charset Sets default character set for a database; charset is the name of a character set; if omitted, character set defaults to NONE.

Example

execute IBEBlock
as
begin
  CREATE DATABASE 'localhost:c:\db2.fdb'
  USER 'SYSDBA' PASSWORD 'masterkey'
  PAGE_SIZE 4096 SQL_DIALECT 3
  DEFAULT CHARACTER SET WIN1251
  CLIENTLIB 'C:\Program Files\Firebird\bin\fbclient.dll';

  CREATE CONNECTION Con1 'localhost:c:\db2.fdb'
  USER 'SYSDBA' PASSWORD 'masterkey'
  CLIENTLIB 'C:\Program Files\Firebird\Bin\fbclient.dll'
  SQL_DIALECT 3 NAMES WIN1251;

  USE Con1;

  ...

  CLOSE CONNECTION Con1;
end