. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 9. Setting The Database
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . set SQL role name -r(ollback) rollback transaction
-sq(l_dialect) set database dialect n -sw(eep) force garbage collection -sh(utdown) shutdown read/write file system regardless of whether only SELECT statements are run or not. Only databases in dialect 3 can be changed to read only mode. The command to set the required mode for a database is: gfix 0 码力 |
44 页 |
247.13 KB
| 1 年前 3
ESQL nor ISQL flavours are described here unless mentioned explicitly. 2.1.2. SQL Dialects SQL dialect is a term that defines the specific features of the SQL language that are available when Chapter Three dialects are available: • Dialect 1 is intended solely to allow backward comptibility with legacy databases from very old InterBase versions, v.5 and below. Dialect 1 databases retain certain language language features that differ from Dialect 3, the default for Firebird databases. ◦ Date and time information are stored in a DATE data type. A TIMESTAMP data type is also available, that is identical
0 码力 |
521 页 |
2.30 MB
| 1 年前 3
ESQL nor ISQL flavours are described here unless mentioned explicitly. 2.1.2. SQL Dialects SQL dialect is a term that defines the specific features of the SQL language that are available when Chapter Three dialects are available: • Dialect 1 is intended solely to allow backward comptibility with legacy databases from very old InterBase versions, v.5 and below. Dialect 1 databases retain certain language language features that differ from Dialect 3, the default for Firebird databases. ◦ Date and time information are stored in a DATE data type. A TIMESTAMP data type is also available, that is identical
0 码力 |
778 页 |
3.43 MB
| 1 年前 3
Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not support reference to @2 datatype DATE must be changed to TIMESTAMP Firebird 2.1 Error Codes -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect @1 does not support reference to @2 datatype -104 335544798 depend_on_uncommitted_rel
0 码力 |
31 页 |
103.24 KB
| 1 年前 3
two SQL “dialects”: dialect 1 and dialect 3. New databases should always be created with dialect 3, which is more powerful in a number of respects. Dialect 1 is a compatibility dialect, to be used only Generator Basics 4 under InterBase 5.6 or earlier. One of the differences between the two is that dialect 1 has no native 64-bit integer type available. NUMERIC(18) columns for instance are stored internally biggest integer type in dialect 1 is the 32-bit INTEGER. In dialect 1 as in dialect 3, generators are 64-bit. But if you assign the generated values to an INTEGER column in a dialect 1 database, they are
0 码力 |
20 页 |
169.00 KB
| 1 年前 3
Attempt to fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect %d does not support reference to %s datatype 335544764 transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect %d does not support reference to %s datatype -104 335544798 depend_on_uncommitted_rel
0 码力 |
26 页 |
157.59 KB
| 1 年前 3
335544764 transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect does not support reference to datatype -104 335544798 depe 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect does not support reference to 335544765 read_only_database Attempted update on read-only database -817 335544766 must_be_dialect_2_and_up SQL dialect is not supported in this database -817 335544793 ddl_not_allowed_by_db_sql_dial
0 码力 |
26 页 |
85.09 KB
| 1 年前 3