Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    5

    Question Unanswered: SQL stored procedure can't use CONTINUE?

    Hi, I used the following in my stored procedure

    Code:
    fetch_loop_daref:
        LOOP
    
    		CONTINUE;
    	
        END LOOP fetch_loop_daref;    
    CLOSE v_getdaref_cur;
    and when I compile it, I got
    SQL0104N An unexpected token "CONTINUE" was found following "daref: LOOP
    ". Expected tokens may include: "COMMIT". LINE NUMBER=501. SQLSTATE=42601

    I remove

    Code:
    CONTINUE;
    it compiled ok.

    my db2 version is 9.7, what am I missing here? Thank you.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    Do you need the ITERATE statement?
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •