Help: export query to csv

IBM's flagship relational database management system
Locked Previous topicNext topic
nello87to
Posts: 1
Joined: Thu May 25, 2017 4:42 pm
Skillset: Cobol, jcl, db2
Referer: Google

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
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
Locked Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”