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?

abhanuc
Profile Answers by abhanuc Questions by abhanuc
Apr 27th, 2006
1
10115

Showing Answers 1 - 1 of 1 Answers

ox

Apr 4th, 2007

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).