firebird 40 language referenceDenis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 3.8.3. PSQL Source for SHOW_LANGS, a procedure involving an array . . . . . . . . . . . . . . . . . . . . . . . . . 0, -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point - 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - DATE '2018-01-19'; time0 码力 | 778 页 | 3.43 MB | 1 年前3
Firebird 2.5 Language ReferenceDmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all accumulating in the tribal lore of the open source community of Firebird core developers and user-developers for 15 years. The gift of the InterBase 6 open source codebase in July 2000 from the (then) Inprise/Borland had been forked by its owners for private, commercial development, it became clear that the open source, non-commercial Firebird community would never be granted right of use. The two important books0 码力 | 521 页 | 2.30 MB | 1 年前3
firebird gfixopposed to being specified on the command line. The file name supplied is not in quotes and must be readable by the user running gfix. If the file name is specified as stdin, then the user will be prompted be split to fit on the page of the PDF version of this manual. In reality, it is a single line of text. Chapter 9. Setting The Database Dialect 19 Chapter 10. Database Housekeeping And Garbage Collection transactions that require Firebird to keep old versions of records that are frequently updated. Another source of garbage is an application strategy that deletes records and never revisits them. What actually0 码力 | 44 页 | 247.13 KB | 1 年前3
firebird gbakopposed to being specified on the command line. The file name supplied is not in quotes and must be readable by the user running gbak. If the file name is specified as stdin, then the user will be prompted the screen, but you can redirect the output to a log file using the -y switch. -Yor the text "suppress" Used in conjunction with the -v[erify] switch to redirect status messages to a file or documentation on this switch mentions that the text should be "suppress_output" rather than "suppress". This is an error in the documentation as the source code for gbak shows that the switch must be "suppress" 0 码力 | 34 页 | 191.73 KB | 1 年前3
firebird 30 sprachreferenz0, -34, 45, 0X080000000; fixed-point - 0.0, -3.14 floating-point - 3.23e-23; string - 'text', 'don''t!'; binary string - x'48656C6C6F20776F726C64' date - DATE '2018-01-19'; time ein beliebiger Text sein, der vom Code-Autor angegeben wird und normalerweise verwendet wird, um zu dokumentieren, wie bestimmte Teile des Codes funktionieren. Der Parser ignoriert den Text von Kommentaren > …]Blockkommentare beginnen mit dem Zeichenpaar /* und enden mit dem Zeichenpaar */. Text in Blockkommentaren kann beliebig lang sein und mehrere Zeilen belegen. Inline-Kommentare beginnen 0 码力 | 701 页 | 3.12 MB | 1 年前3
Firebird File and Metadata Security. . . . . . . . . . . . . . . . . . . . . . . . 9 4.2.5. Deleting stored procedure and trigger source code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 5. Embedded Firebird server where the SYSDBA password is known. Firebird is an open source product. If the encryption facilities were built in, or open source plug-in libraries were used, it would be feasible for users to procedure and trigger source code When you write and define a stored procedure or trigger for a Firebird database, the server stores an almost complete copy of the procedure source code along with a “compiled”0 码力 | 19 页 | 115.27 KB | 1 年前3
firebird language reference 30 rus......................................................................... 366 ON EXTERNAL [DATA SOURCE] ........................................................................ 366 Особенности пула подключений процессора, PDF и т.д.). • Подтип 1 (TEXT): Подтип 1 имеет псевдоним TEXT, который может быть использован вместо указания номера подтипа. Например, BLOB SUBTYPE TEXT. Это специализированный подтип, который _ascii x'4E657276656E' FROM rdb$database -- returns 'Nerven' (same string, now interpreted as ASCII text) SELECT _iso8859_1 x'53E46765' FROM rdb$database -- returns 'Säge' (4 chars, 4 bytes) SELECT _utf80 码力 | 719 页 | 3.98 MB | 1 年前3
MSSQL to Firebird RussianСимволные данные фиксированной длины (Unicode). Максимальная длина 4000 сим- волов. 7 ntext BLOB SUB_TYPE TEXT Символьные данные переменной дли- ны (Unicode). Максимальная длина 230-1 (1073741823) символов. эквивалента Промежуточные результаты выполнения запроса для последующего использова- ния. 6.5 text BLOB SUB_TYPE TEXT Символьные данные переменной длины (не-Unicode). Максимальная длина 231-1 (2147483647) символов /************************************************************** GUID_CREATE Returns a GUID (cstring(36), standard readable representation of a UUID in the xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx format) Parameters: cstring(36)0 码力 | 22 页 | 287.07 KB | 1 年前3
firebird gsecopposed to being specified on the command line. The file name supplied is not in quotes and must be readable by the user running gsec. If the file name is specified as stdin, then the user will be prompted Firebird 2.5 onwards, the display command shows an additional column named admin. This shows the text admin where a user has been granted the RDB$ADMIN role either within the database, or by using gsec you were running in batch mode. By redirecting input from a command file, gsec will read a line of text from that file any time it requires user input. By forcing it to read the quit command, you make0 码力 | 23 页 | 145.31 KB | 1 年前3
firebird isqlFirebird version 1.5 and higher. Chapter 1. Introduction 4 Chapter 2. Overview The isql utility is a text-mode client tool located in the bin directory of the Firebird installation. It provides a command changes, create a new database with identical schema definitions or new ones, or create a new database source file. Using -m2 and -m(erge) The command line switch -m2, has been added in Firebird 2.0 and can commands: BLOBDUMP-- dump BLOB to a file BLOBVIEW -- view BLOB in text editor EDIT [ ] -- edit SQL script file and execute EDIT -- 0 码力 | 76 页 | 369.92 KB | 1 年前3
共 36 条
- 1
- 2
- 3
- 4













