Originally posted by: SystemAdmin

Hello! Have a 6.7.1 MDQ query on XP that is not working completely.

The mdq is read into an input card on a simple input to output map. The query is on an Access database, the initial Select works fine but just added an Order By SSN and it is not sorting the input database table based on the output file results, which is a text copy of the input database table with only a few of the orignal columns.

The map was built once more after the mdq was updated to make sure the changes were picked up from the query in the mdq file. Not sure if something else needs to be checked here or if expecting some results that will not happen.

Would assume that if the input query is ordering the database table by SSN then the output file will have the records sorted by SSN as well.

Hopefully someone can provide some help with the above processing.

Thanks!
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender