Help, please
Posted in 1997
The matter is I'm confused with DECLARE CURSOR.
Before I've done the similar script with that without a problem.
Now when 7.2.3 version was installed on the RA Informix
doesn't want to understand DECLARE at all ;o(
The most interesting is I can't execute CURSOR on the old
machine("shadow")
Well, could you take a look on my script although I've checked it
carefuly
with Informix Manual or may be we gotta call in
Technical Supprot of Informix?
Thanks in advance.
P.S. The SQL server gives syntaxis error on "DECLARE"
DECLARE login_cursor_id CURSOR FOR
SELECT login_code FROM cfg_agent_login FOR UPDATE OF dbid; login_id INTEGER = 100;
log VARCHAR(32);
OPEN login_cursor_id;
WHILE EXISTS(
FETCH login_cursor_id INTO log;
EXIT WHEN login_cursor_id%NOTFOUND;
UPDATE cfg_agent_login SET dbid = login_id+1
WHERE current of login_cursor_id;login_id := login_id+1;
END WHILE;
CLOSE login_cursor_id;
--
phone (415)437-1065
fax (415)437-1260
pager (415)207-9593
georget-pager@genesyslab.com
<georget@genesyslab.com>