If I have defined an alternate key with duplicates on a file (so non unique values are allowed for this alternate key) and I do a read by use of this alternate key, it seems it does only read one record of the possible identical values for this alternate key.
Example
Key Alternate Key
1 A
2 A
3 B
4 B
read (first time): 1 -- A
read next : 3 -- B
It did skip 2 -- A: is this normal? And if so, how to read all the records without skipping the 2 -- A record?
Example
Key Alternate Key
1 A
2 A
3 B
4 B
read (first time): 1 -- A
read next : 3 -- B
It did skip 2 -- A: is this normal? And if so, how to read all the records without skipping the 2 -- A record?