allow backward scan does not work

[CR #401543] The configuration parameter allow backward scan does not work in Adaptive Server Enterprise version 15.0.

Workaround: If you are encountering increased deadlocks while executing backward scans, separate problematic scans:

  1. Select the required rows into a temporary table in ascending order.

  2. Select from the temporary table in descending order.