Fetching one cousor within DO loop of another cursor

5 pts.
Tags:
SQLRPGLE
Is the below scenerio possible, if yes then how? CREATE C1 CURSOR OPEN CURSOR C1 FETCH C1 CURSOR DOW SQLCOD = 0 (For Cursor C1) CREATE C2 CURSOR OPEN CURSOR C2 FETCH C2 CURSOR DOW SQLCOD = 0 (For Cursor C2) CLOSE CURSOR C2 FETCH CURSOR C2 ENDDO FETCH CURSOR C1 ENDDO CLOSE CURSOR C1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You essentially had all the steps you need. It just appears you were trying to close C2 too soon

<pre>
CREATE C1 CURSOR
OPEN CURSOR C1
FETCH C1 CURSOR
DOW SQLCOD = 0 (For Cursor C1)
CREATE C2 CURSOR
OPEN CURSOR C2
FETCH C2 CURSOR
DOW SQLCOD = 0 (For Cursor C2)

FETCH C2 CURSOR
ENDDO
CLOSE CURSOR C2
FETCH CURSOR C1
ENDDO
CLOSE CURSOR C1
</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following