- as per checking the application is not generating a text file because the query has an error. check and fix the error for the successful generation of file.
- test the modified query in the application, generate a textfile and debug if the query will not encounter an error again
- generate the textfile and check if the text file output is correct versus in the data in the database and the given sample data by the sm
- as per checking  and testing the modification is now OK and the data extracted and text file output is tally with the database