stored procedure that generates data for mailing labels (from employee.fdb): CREATE PROCEDURE mail_label (cust_no INTEGER) RETURNS (line1 CHAR(40), line2 CHAR(40), line3 CHAR(40), line4 CHAR(40) constructs Available in PSQL Syntax [label:] WHILE DO Table 103. WHILE … DO Parameters Argument Description label Optional label for LEAVE and CONTINUE. Follows the SELECT, FOR EXECUTE STATEMENT 7.7.10. BREAK Used for Exiting a loop Available in PSQL Syntax [label:] BEGIN ... BREAK; ... END ::= FOR INTO

cache is an area of RAM allocated to store (cache) database pages in memory to help improve the efficiency of the database performance. It is far quicker to read data from memory that it is to have to

gespeicherten Prozedur, die Daten für Adressetiketten generiert (aus employee.fdb): CREATE PROCEDURE mail_label (cust_no INTEGER) RETURNS (line1 CHAR(40), line2 CHAR(40), line3 CHAR(40), line4 CHAR(40) Schleifenkonstrukte Verfügbar in PSQL Syntax [label:] WHILE DO Tabelle 96. WHILE … DO Parameters Argument Beschreibung label Optionales Label für LEAVE und CONTINUE. Befolgt die EXECUTE STATEMENT 7.7.9. BREAK Verwendet für Verlassen einer Schleife Verfügbar in PSQL Syntax [label:] BEGIN ... BREAK; ... END ::= FOR INTO

Синтаксис: [label:] {FOR | WHILE ()} DO BEGIN ... LEAVE [label]; ... END Таблица 6.10. Параметры оператора LEAVE Параметр Описание label Метка. select_stmt Синтаксис: [label:] {FOR | WHILE ()} DO BEGIN ... CONTINUE [label]; ... END Таблица 6.11. Параметры оператора CONTINUE Параметр Описание label Метка. select_stmt данных SQL с диалектом @1 не поддерживает ссылку на @2 тип данных. -104 336003087 dsql_invalid_label Label @1 @2 in the current scope. Метка @1 @2 находится в текущей зоне видимости. -104 336003088 d

stored procedure that generates data for mailing labels (from employee.fdb): CREATE PROCEDURE mail_label (cust_no INTEGER) RETURNS (line1 CHAR(40), line2 CHAR(40), line3 CHAR(40), line4 CHAR(40) STATEMENT 7.6.7. LEAVE Used for Terminating a loop Available in PSQL Syntax [label:] BEGIN ... LEAVE [label]; ... END ::= FOR INTO DO | FOR DO | WHILE ()} DO Table 86. LEAVE Statement Parameters Argument Description label Label Chapter 7. Procedural SQL (PSQL) Statements 281 Argument Description select_stmt SELECT statement

dialect does not support reference to datatype -104 336003087 dsql_invalid_label Label in the current scope -104 336003088 dsql_datatypes_not_comparable Datatypes

Database SQL dialect %d does not support reference to %s datatype -104 336003087 dsql_invalid_label Label %s %s in the current scope -104 336003088 dsql_datatypes_not_comparable Datatypes %sare not comparable

Database SQL dialect @1 does not support reference to @2 datatype -104 336003087 dsql_invalid_label Label @1 @2 in the current scope -104 336003088 dsql_datatypes_not_comparable Datatypes @1are not comparable

прекращения блока внешнего цикла. Синтаксис: [label:] {FOR | WHILE} ... DO ... (здесь возможны вложенные циклы, с меткой или без неё) ... LEAVE [label]; Пример: В приведённом ниже примере при ошибке