issue #20044: Make non-nested the default option for retrieve record, make obtaining a lock optional and false by default.