![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » SQL/PSM Functions » EOF |
EOF(<CursorName>) <CursorName> = Previously-opened result set cursor
BOOLEAN
-- This procedure uses an IF statement -- to conditionally test if the State column -- is equal to 'FL', and if so, to change it -- to 'NY' -- The whole update process is wrapped inside -- of a transaction start..commit/rollback block CREATE PROCEDURE UpdateState() BEGIN DECLARE CustCursor CURSOR WITH RETURN FOR Stmt; DECLARE State CHAR(2) DEFAULT ''; PREPARE Stmt FROM 'SELECT * FROM Customer'; OPEN CustCursor; START TRANSACTION ON TABLES 'Customer'; BEGIN FETCH FIRST FROM CustCursor ('State') INTO State; WHILE NOT EOF(CustCursor) DO IF (State='FL') THEN UPDATE CustCursor SET 'State'='NY'; END IF; FETCH NEXT FROM CustCursor ('State') INTO State; END WHILE; COMMIT; EXCEPTION ROLLBACK; END; END
Deviation | Details |
Extension | This function is an ElevateDB extension. |
This web page was last updated on Friday, January 31, 2025 at 08:42 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |