------------------------------ Введенные команды ------------------------------
connect to XXX8 user XXXX1 using ********;
------------------------------------------------------------------------------
connect to XXX8 user XXXX1 using       

   Информация соединения с базой данных

 Сервер баз данных           = DB2 OS/ 390   8 . 1 . 5 
 ID авторизации SQL          = XXXX1
 Алиас локальной базы данных = XXX8

------------------------------ Введенные команды ------------------------------
CREATE PROCEDURE pof6661 
LANGUAGE SQL
WLM ENVIRONMENT XXX8XXXX
BEGIN
 DECLARE q INT;
 FOR my_loop AS  SELECT a FROM musor  DO 
  SET q =  1 ; 
 END FOR;
END|
 |
------------------------------------------------------------------------------
CREATE PROCEDURE pof6661 LANGUAGE SQL WLM ENVIRONMENT XXX8XXXX BEGIN DECLARE q INT; FOR my_loop AS  SELECT a FROM musor  DO SET q =  1 ; END FOR; END
DB20000I  Команда SQL выполнена успешно.

ALTER VIEW my_view MODIFY  (  CONSTRAINT  constr1 RELY );

ALTER VIEW my_view MODIFY  (  CONSTRAINT  constr1 RELY );

SQL> alter table raccount add constraint conav check(account>' ');
Table altered.

SQL> alter table raccount modify (constraint conav rely);
alter table raccount modify (constraint conav rely)
                                              *
ERROR at line  1 :
ORA- 00904 : "RELY": invalid identifier

SQL> alter table raccount modify constraint conav rely;
Table altered.