08-04-2009 9:24 AM
HI All,
We have a Query for tables EBAN and EBKN with some additional fields fetched from Add-On Tables.
This Query had a performance issue, therefore we created new Program with the existing logic of Query.
This program woks well with improved performance. But the order of the records (Sorting)is different from the Query however the number of records and the data is absolutely correct.
On analysis found that in Query FGroups was used and the sorting was done by command 'SORT AS TEXT' on the extract dataset. But i could not figure out the fields on which the sorting happening in the query.
Would like to know the SORTING order in this situation !! Has anybody faced this issue ? Any input will be appreciable.
Thanks In Advance.
Praveen
08-05-2009 2:31 AM