MVSFORUMS.com

[sharada]

Hi,

I am facing a problem in reading a table in Datacom.

I have a key for which there are multiple rows in the table, so I tried to get the rows one by one by placing the read logic in loop, but the problem
is the same row is getting read all the times, and the program is going in loop.

Anybody knows how to solve this???
_________________
Regards,
Sharada.

Always perform your duty efficiently and without any selfish attachment to the results,
because by doing work without attachment one attains Supreme.

[kolusu]

sharada,

You need to work on explanatory titles. You need to remember that you are not in auction hall and yelling out will not help you.

coming to your problem, I am guessing that it is more of a programming error than a database issue.


Try this

1. Since you have multiple keys, take a count of no: of dups in the table for just 1 key.

2. Now perform the read paragraph exactly "count" times from step 1 with a display of each
key

3. Now check to see if you are reading the same key over and over.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[bstillwa]

What commands are you using? The first command must be REDKG (read key greater or equal), followed by REDNX (read next). If only REDKG is used, then yes, you will only retrieve the same record over and over.
_________________
Bev.