Re: Help, please

In article <344D2B0F.339CAD75@weideneder.de>, Stefan Weideneder <stefan@weideneder.de> wrote: > > georget wrote: > > > > 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> > > Hi, > > I have no idea where there is a problem, but I had some > problems with the trailing part "OF dbid" at the end > of the cursor declaration. Try it with "... FOR UPDATE;". > > Bye > > Stefan I could be totally off the mark here, but didn't Informix at some point disallow DECLARE CURSOR ... FOR UPDATE syntax? -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet