Skip to main content

We are trying to update from version 8.1.3.1 to 10.0 and are getting an File error 93 when attempting to sort. The sort statement is shown below. We use 2 separate Select statements for the using and giving files, but they both reference the same physical file. Has something changed since version 8.1.3.1 that prohibits this?

Thanks

David

              Sort PolicySearchSrt
                 On Ascending  Key PolicySearchSrt-Policy-Status
                 On Descending Key PolicySearchSrt-Bitmap-Switch
                 On Descending Key PolicySearchSrt-Policy-Key
                 On Descending Key PolicySearchSrt-Insured
                    With Duplicates In Order
                       Using InPolicySearch
                          Giving PolicySearch

We are trying to update from version 8.1.3.1 to 10.0 and are getting an File error 93 when attempting to sort. The sort statement is shown below. We use 2 separate Select statements for the using and giving files, but they both reference the same physical file. Has something changed since version 8.1.3.1 that prohibits this?

Thanks

David

              Sort PolicySearchSrt
                 On Ascending  Key PolicySearchSrt-Policy-Status
                 On Descending Key PolicySearchSrt-Bitmap-Switch
                 On Descending Key PolicySearchSrt-Policy-Key
                 On Descending Key PolicySearchSrt-Insured
                    With Duplicates In Order
                       Using InPolicySearch
                          Giving PolicySearch

Not intentionally.  The SORT verb file handling was updated in 10.0, but the behavior should be the same.  There was one issue found when the USING and GIVING files are the same.  This issue is fixed in 10.0.1 by ECN-4400.  It's possible this issue is causing your problem.

We are trying to update from version 8.1.3.1 to 10.0 and are getting an File error 93 when attempting to sort. The sort statement is shown below. We use 2 separate Select statements for the using and giving files, but they both reference the same physical file. Has something changed since version 8.1.3.1 that prohibits this?

Thanks

David

              Sort PolicySearchSrt
                 On Ascending  Key PolicySearchSrt-Policy-Status
                 On Descending Key PolicySearchSrt-Bitmap-Switch
                 On Descending Key PolicySearchSrt-Policy-Key
                 On Descending Key PolicySearchSrt-Insured
                    With Duplicates In Order
                       Using InPolicySearch
                          Giving PolicySearch

Thank you. I know version 10.0.1 was due out today, hopefully that will fix it.

Terms & ConditionsAccessibility statement