SAS/ACCESS Interface to CA-DATACOM/DB: Reference

Direct Addressing and Access by Row Number

Direct (random) addressing is supported by the SAS/ACCESS interface to CA-DATACOM/DB. However, access by row number is not supported, because qualified records can float around if your updates or other users' deletions move the records out of your WHERE clause context.

For example, if you are on row 3 while someone else is deleting row 4, you go forward to row 5. In another situation, if you update row 3 so that it no longer matches your WHERE clause, it is gone if you ever try to go back to it (even in the same session). CA-DATACOM/DB re-evaluates each retrieval against the WHERE clause and will not return data records that once qualified but currently do not qualify.

Chapter Contents
Previous
Next
Top of Page