Page 1 of 1

Help: export query to csv

PostPosted: Thu May 25, 2017 4:47 pm
by nello87to
how can I export in a CSV file the result of a SELECT query from Mainframe DB2 in Batch mode? I have tried the FILE MANAGER online mode and it works but I need to use the batch mode for a better performance. I can also use ISQL but I don't know which parameters I have to use to create a CSV file. Thanks

Re: Help: export query to csv

PostPosted: Thu May 25, 2017 6:38 pm
by NicC
If you do not know the parameters then read the manual.

What is stopping you from going the File Manager route in batch? You can use the online to generate a batch job that you can then use as a basis for your current SQL job.

Re: Help: export query to csv

PostPosted: Fri May 26, 2017 4:39 am
by NicC
I found this question on another forum - this is being locked.