Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
davidr262 Absent Member.
Absent Member.
943 views

Sort statement

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

0 Likes
2 Replies
mhanson Absent Member.
Absent Member.

RE: Sort statement

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.

0 Likes
davidr262 Absent Member.
Absent Member.

RE: Sort statement

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.