| |
GeekInterview.com > Interview Questions > Database
| Print | |
Question: I need to export data in Mainframe DB2 tables on to my PC as IXF files. Are there any commands I can use from QMF or SPUFI or any other Mainframe source to do this?
|
| April 04, 2007 13:54:11 |
#1 |
| ox |
Member Since: Visitor Total Comments: N/A |
RE: I need to export data in Mainframe DB2 tables on t...
|
in the task bar type (after the QMF returns your query results)-
EXPORT REPORT TO filename.txt
hit enter and the console will display the complete name of the data set to which your results have been exported. eg; V1PRD.DB2Q.FILENAME.TXT
Now just use the File Transfer utility (Normally under the Menu ISPF Commands)
and fetch the results file using FTP or direct IP connection (depending on your connectivity mode) by providing the complete filename (V1PRD.DB2Q.FILENAME.TXT in this case).
|
| |
Back To Question | |
