. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266 7.5.1. Firing Order (Order of Execution) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . CREATE PROCEDURE P(APARAM INT) RETURNS (B INT) AS BEGIN /* This text will be ignored during the execution of the statement since it is a comment */ B = A + 1; -- In-line comment SUSPEND; END expressions are evaluated directly during parsing, as though the statement were already prepared for execution. Thus, even if the query is run several times, the value of, for instance, timestamp 'now' remains

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 352 7.6.1. Firing Order (Order of Execution) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . CREATE PROCEDURE P(APARAM INT) RETURNS (B INT) AS BEGIN /* This text will be ignored during the execution of the statement since it is a comment */ B = A + 1; -- In-line comment SUSPEND; END parsing, as though the Chapter 3. Data Types and Subtypes 60 statement were already prepared for execution. As this produced unexpected or confusing results when using the datetime mnemonics like 'NOW'

handling is a programming construct designed to handle an occurrence that disrupts the normal execution of a program. These are called errors. Exceptions are user-defined named error messages, written SQLCODE Message Meaning <0 SQLERROR Error occurred: statement did not execute 0 SUCCESS Successful execution +1 to +99 SQLWARNIN G System warning or information message +100 NOT FOUND No qualifying rows causes all the SQL commands being executed to be displayed on the output device prior to their execution. You may wish to turn echo off as part of a script file although the isql default is for echo to

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 5.7. Rows affected by query execution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . operation equals op_sql_response: SQL response if not: Generic response 5.7. Rows affected by query execution Obtain the rows affected by a query is done using the statement information request message List 2020 M R Conversion to AsciiDoc, minor copy-editing 0.1 5 26 Dec 2021 AP Document batch execution Appendix C: Revision history 39

-901 335544731 tra_must_sweep -901 335544740 udf_exception A fatal exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 Updated 04/30/04 p. 15 -901 335544767 blob_filter_exception A fatal exception occurred during the execution of a blob filter. -901 335544768 exception_access_violation Access violation. The code attempted

-901 335544731 tra_must_sweep -901 335544740 udf_exception A fatal exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 RDB$USER_PRIVILEGES -901 335544767 blob_filter_exception A fatal exception occurred during the execution of a blob filter. -901 335544768 exception_access_violation Access violation.The code attempted

-901 335544731 tra_must_sweep -901 335544740 udf_exception A fatal exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 RDB$USER_PRIVILEGES -901 335544767 blob_filter_exception A fatal exception occurred during the execution of a blob filter. -901 335544768 exception_access_violation Access violation.The code attempted

operating systems allow the system administrator to set file system permissions which prevent execution of certain programs and utilities for security reasons. The Firebird database holds details of

operation will be completed successfully. (In pre-2.0 Firebird, this too would cause an error and halt execution.) See also the section below, Expressions involving NULL�, about concatenating in expressions

operation will be completed successfully. (In pre-2.0 Firebird, this too would cause an error and halt execution.) See also the section below, Expressions involving NULL, about concatenating in expressions involving