I would like to know how to export data returned from a sql query to something that I can work with, such as a text file or anything I can bring over to my windows environment.
Steps to reproduce:
1.) at command line type "strsql" + enter
2.) at "Enter SQL Statements" screen type "select * from <library>/<datafile>" + enter (you pick the library and datafile)
3.) A "display data" screen will appear showing rows and columns filled with data.
To have an option available to save the data to a human-usable file (such as a text file).
The screen shown titled "Display Data" displays the data but does not provide an option to output the data to a human-usable file.
Can someone please let me know how to work with sql results? I'm open minded in terms of how it gets done; ultimately I would like to output the results to excel by any means necessary.