5.11. PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 5.11.1. CREATE PACKAGE. . . . 11.2. ALTER PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 5.11.3. CREATE OR ALTER PACKAGE . . . . . . 5.11.4. DROP PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 5.11.5. RECREATE PACKAGE . . . . . . .

SQL СУБД Firebird 3.0 9 PACKAGE .............................................................................................................................. 194 PACKAGE .......................... ................................................................................... 194 CREATE PACKAGE .............................................................................................. 194 .................................................................................... 198 ALTER PACKAGE ................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 18.14. SET NAMES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . -c(ache) number of cache buffers -ch(arset) connection charset (set names) -d(atabase) database name to put in script creation -e(cho) COLLATION, DATABASE, DOMAIN, EXCEPTION, FILTER, FUNCTION, GENERATOR, GRANT, INDEX, PACKAGE, PROCEDURE, ROLE, SQL DIALECT, SYSTEM, TABLE, TRIGGER, VERSION, USERS, VIEW EXIT

with FirebirdSS, Classic packages with FirebirdCS. For Windows, there is a combined installation package; you choose the architecture during the installation process. Embedded Server for Windows On Windows firebirdsql.org/pdfmanual/Using-Firebird_(wip).pdf (PDF) The Embedded Server comes in a separate download package. What is in the kit? All of the kits contain all of the components needed to install the Firebird and other Unix-like platforms In all cases, read the Release Notes that came with your Firebird package (chapter Installation Notes, section Posix Platforms). There may be significant variations from release

components on Windows and Linux. Warning Firebird 1.0 still uses many of the same locations, component names and resource links as InterBase 6.x and prior versions of InterBase. Hence, it is not possible to install Firebird. The Windows executable installa- tion script, the Linux rpm (RPM Package Manager, originally RedHat Package Manager) program and the official .tar.gz for other Posix platforms perform some rpm installs, consult the appropriate platform document- ation for instructions about using RPM Package Manager. In most distributions you will have the choice of performing the install from a command

5.11. PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202 5.11.1. CREATE PACKAGE. . . . 11.2. ALTER PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204 5.11.3. CREATE OR ALTER PACKAGE . . . . . . 5.11.4. DROP PACKAGE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206 5.11.5. RECREATE PACKAGE . . . . . . .

the ".gdb" extension that used to be the Borland convention for suffixing InterBase database file names. The issue is described in more detail in Other Win32 Issues at the end of the Windows installation preferred way to do this was to install the vcredist_32 or vcredist_64 Microsoft installer (.msi) package, as appropriate for the architecture of your host server, from the Microsoft support site. For Windows Unfortunately, some of the earlier docu- mentation applicable to Firebird 2.0 erroneously cited the names of the older runtimes used by Firebird 1.5, Installing on Windows 19 (msvcrt.dll and the C++ runtime

Installation kits At the Firebird website, https://firebirdsql.org, the installation kits have names like: Firebird-5.0.0.bbbb-p-windows-x64.exe Windows executable installer, 64 bits Firebird-5.0 bbbb-p-linux-x64.tar.gz Linux compressed tarball Firebird-5.0.0.bbbb-p-macos-x64.pkg Mac OS-X 64-bit package ...where bbbb is the build number (e.g. 1227 for Firebird 5.0.0 Release Candidate 1) and p the subsequent servers must be installed and configured manually. They need to have different service names and should listen on different TCP/IP ports. The file install_windows_manually.txt in the doc subdirectory

Software BV (Netherlands) Mitaro Business Solutions (Liechtenstein) Other Donors Listed below are the names of companies and individuals whose cash contributions covered the costs for translation into English available. ◦ Double quotes are reserved for delimiting non-regular identifiers, enabling object names that are case-sensitive or that do not meet the requirements for regular identifiers in other ways Some keywords are reserved, meaning their usage as identifiers for database objects, parameter names or variables is prohibited in some or all contexts. Non-reserved keywords can be used as identifiers

. . . . . . . . . . . . . . . . . . . . . . . . . . . 29 7.5. Use of 'stdin' or 'stdout' File Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . avoid creating an intermediate dump file. The commands above assume that there are suitable alias names set up for both emptest and emptest_2. If not, you will need to supply the full path to the two databases examples of backing up and restoring remote databases over ssh, using the stdin and stdout file names, can be seen below. 6.10. Backup & Restore With & Without Shadow Files. Databases can have shadow