Help: export query to csv



IBM's flagship relational database management system

Help: export query to csv

Postby nello87to » Thu May 25, 2017 4:47 pm

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
nello87to
 
Posts: 1
Joined: Thu May 25, 2017 4:42 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help: export query to csv

Postby NicC » Thu May 25, 2017 6:38 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Help: export query to csv

Postby NicC » Fri May 26, 2017 4:39 am

I found this question on another forum - this is being locked.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post