A_ORA_USE_PRIMARY configuration variable

Acu4GL adds the segments of the primary key to the ORDER BY clause when reading on an alternate key that allows duplicates. This is done to insure that the keys are returned in a predictable order should the application change the direction it is reading the information in. Your application can now control whether or not this occurs.

Setting the variable A_ORA_USE_PRIMARY to FALSE will prevent the addition of the primary key segments to the ORDER BY clause for alternate keys allowing duplicates. The default of TRUE maintains the current functionality of adding the primary key segments. This variable is checked at the time of file open and may be set differently for different files.