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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 at 23:03

Your Answer


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

Browse other questions tagged or ask your own question.