Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

in db2-luw, I can create a csv using the export command. However, running the same command in z/os results in:

SQL1325N The remote database environment does not support the command or one of the command options.

How do I export a table to csv in db2 v10 for z/os?

Here is the command that works on luw, but not on z/os.

export to D:\test.csv of del modified by nochardel select * from gp.mytable
share|improve this question
    
If you don't have access to the mainframe, you could try using IBM Data Studio to save the results of your query. If you do have access to the mainframe, that would be a different question. –  mustaccio Mar 5 at 23:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.