I feel embarrassed to ask, since I've been doing this way long enough to know the answer, but my mind has gone blank on me: When creating a remote view as in

"CREATE SQL VIEW Potential_Underpayments_View1 REMOTE CONNECTION qcm_Connect1 SHARE ;
AS SELECT ; " etc, etc.

for example or when running a pass-thro query such as in:

"lcSQLQry = 'SELECT h.short, pats.pat_type, pats.totchg AS pttotchg, ' + ;
= SQLPREPARE(gnConnHandle, lcSQLQry, 'Some_Cursor')
= SQLEXEC(gnConnHandle)" etc, etc.

What is the DBSETPROP() or other related command that will apply only a "shared" lock on the target table in an MS SQL database and will prevent applying an "Exclusive" lock on that table? /psb