| Information for the Database Administrator |
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
