Subject | Newbie isql scripting |
---|---|
Author | jeff_xky |
Post date | 2006-09-16T16:55:47Z |
Howdy,
I'm working my way through Borrie's Firebird Book, and have hit a
weird roadblock with scripts. This script:
SET SQL DIALECT 3;
CREATE DATABASE 'c:\databases\test.fdb'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1
USER 'SYSDBA' PASSWORD 'masterkey';
fails with:
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 4, char 2
-USER
SQL>
I've created the script with both notepad and vi (on a connected linux
system) - it ends with several blank lines. I'd appreciate the loan of
a clue :)
Thanks,
Jeff Elkins
I'm working my way through Borrie's Firebird Book, and have hit a
weird roadblock with scripts. This script:
SET SQL DIALECT 3;
CREATE DATABASE 'c:\databases\test.fdb'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1
USER 'SYSDBA' PASSWORD 'masterkey';
fails with:
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 4, char 2
-USER
SQL>
I've created the script with both notepad and vi (on a connected linux
system) - it ends with several blank lines. I'd appreciate the loan of
a clue :)
Thanks,
Jeff Elkins