[Info-vax] Indexed RMS file question
J Xenu
j_xenu at hotmail.com
Fri Oct 2 14:34:22 EDT 2009
Thanks, Hein.
So, I take it that I would have to create a key which is String1+String2
appended to do the second kind of read (read a record which matches both strings)?
My real question was actually, if I restrict the range to all records matching
the first key, give me a record which (also) matches the second key. From
studying the doc online, it appears I can't specify two keys and read only
records that match both keys.
Assuming that two records match my key, if I do an indexed read followed by a
sequential read, will I get both records in the same order? I realize I will
have to check the results of the second read to see if the key actually does still
match, if there was only one matching record it wouldn't.
Sorry for my poor explanation, but in my example, key3 was a range.
I want a call to read with a
key of "Beta 0042" to match the record "Beta 33-50 This is the data I want",
key of "Beta 0033" to also match that record,
key of "Beta 0047" to also match that record,
key of "Beta 0055" to NOT match (and return a RMS-E-RNF type error) and
key of "Beta 0020" to NOT match (but match the record "Beta 12-32 even more data").
Maybe we should look at some Oracle-type product, but that seems overblown
for this.
I can arrange the order of the data and make the numbers strings, however.
More information about the Info-vax
mailing list