The NO-WAIT option works for DataServer applications in the same way that it works for OpenEdge applications: the DataServer uses a time-out mechanism. If MS SQL Server does not return a record, the DataServer considers the record to be locked. It then cancels the request to the MS SQL Server and sets the "locked" and "not available" conditions.

During a period of heavy demand, you might encounter situations where the "not available" condition is set although the record is not currently locked by a user. In this case, you might want to increase the time-out interval by using the -Dsrv RESP_TIMEOUT parameter.