redord retrieval in SQLRPG

1150 pts.
Tags:
Embedded SQL
SQLRPGLE
Hi, can anybody tell me how to retrieve a record randomly using cursors...(say 8th record) using SQLRPG(Embedded sql)

Answer Wiki

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

Hi,

I think you should be able to define a cursor, then do a fetch first, then do a fetch relative +7. It’s not something I’ve ever needed to use, but I think it should work. Something like this :-

<b>/EXEC SQL
+ DECLARE C1 CURSOR FOR <select statement goes here>
/END-EXEC

/EXEC SQL
+ FETCH FIRST FROM C1
/END-EXEC

/EXEC SQL
+FETCH RELATIVE +7 FROM C1
/END-EXEC</b>

Another option would be to use a select by RRN :-

<b>/EXEC SQL
+ DECLARE C1 CURSOR FOR <select statement goes here>
/END-EXEC

/EXEC SQL
+ FETCH FIRST FROM C1
/END-EXEC</b>

In your select statement you specify something like :-

<b>SELECT field1, field2 FROM yourfile WHERE RRN(yourfile) = :RRN</b>

Don’t forget to define your RRN field in your RPG before you do the DECLARE CURSOR and fill the field before you do the FETCH statement.

Regards,

Martin Gilbert.

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