Subject | Create Database |
---|---|
Author | Uwe Oeder |
Post date | 2004-03-17T14:37:58Z |
Please point out the obvious to me why PAGE_SIZE is not anymore recognised
in the create database statement. Did I go over a limit or something. Oddly
it does still create the database file and gfix reports no errors.
C:\Firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
SQL> PAGE_SIZE = 8192
CON> DEFAULT CHARACTER SET NONE ;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 1
-PAGE_SIZE
SQL>
SQL> -- Select the database
SQL>
CON> CONNECT 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
Commit current transaction (y/n)?y
Committing.
Database: 'D:\Test2\Data.FDB', User: sysdba
in the create database statement. Did I go over a limit or something. Oddly
it does still create the database file and gfix reports no errors.
C:\Firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
SQL> PAGE_SIZE = 8192
CON> DEFAULT CHARACTER SET NONE ;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 1
-PAGE_SIZE
SQL>
SQL> -- Select the database
SQL>
CON> CONNECT 'D:\Test2\Data.FDB'
CON> user 'sysdba'
CON> password 'masterkey' ;
Commit current transaction (y/n)?y
Committing.
Database: 'D:\Test2\Data.FDB', User: sysdba