The old joke - where the programmer thinks he is, but the DBMS knows he is not. Currency is the location within the database during run-unit execution. There are four levels of currency: current of run-unit
Locks may be shared or exclusive. Shared means that other run units can retrieve the record but can not modify it. Exclusive means that other run units can neither retrieve nor modify it. Record locks
Find tells you whether the record is actually in the database. If it is not found you save the overhead of an obtain.
If you are current on the owner of a set, what is the difference between an obtain next and obtain first?
No difference. There is a difference between obtain first and obtain next for an area sweep, but not when current on the owner in a set.
How to write a IDMS code to find whose employee last name is starting with J and first name starts with H.
Latest Answer : Yes, by using the OBTAIN FIRST/NEXT within area/set name command. However if you have more than one record type in the area, or a multi-member set you won't know what you have. You should only use this on one-record type sets/areas.... and really for ...