使用变量更新集合

图: 使用变量更新集合。

CREATE PROCEDURE new_report(mgr VARCHAR(30),
          old VARCHAR(30), new VARCHAR(30) )
          
          DEFINE s SET (VARCHAR(30) NOT NULL);
          DEFINE n VARCHAR(30);
          
          SELECT direct_reports INTO s FROM manager
          WHERE mgr_name = mgr;
          
          FOREACH cursor1 FOR
          SELECT * INTO n FROM TABLE(s)
          IF ( n == old ) THEN
          UPDATE TABLE(s)(x)
          SET x = new WHERE CURRENT OF cursor1;
          EXIT FOREACH;
          ELSE
          CONTINUE FOREACH;
          END IF;
          END FOREACH
          
          UPDATE manager SET mgr_name = s
          WHERE mgr_name = mgr;
          
          END PROCEDURE;