DB2 while 写法,该怎么处理_DB2

DB2 while 写法
如何  求DB2 自定义函数中while写法

哪个高手帮个忙  谢谢
------解决方案--------------------------------------------------------
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0005655.htm?resultof=%22%77%68%69%6c%65%22%20

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.apdv.sql.doc/doc/c0024353.htm?resultof=%22%77%68%69%6c%65%22%20

       WHILE v_counter < (v_numRecords / 2 + 1) DO
         FETCH c1 INTO medianSalary;
         SET v_counter = v_counter + 1;
       END WHILE;