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

I've been handed a task where we need to dump specific tables in a progress database (10.2B) to pipe-delimited flat files (50+ tables) and send them to a third party for analysis every week.

Looking at the sqldump command it seems it only supports comma delimited or quoted... but I have data in these tables with both commas and quotes.

How can I do this?

share|improve this question

If you're ok with writing some code:

OUTPUT TO VALUE("filename.d"). 

FOR EACH table-name:
EXPORT DELIMITER "|" table-name.


It's possible to write something that's more automated than this if you're interested.

share|improve this answer

Data Administration tool > export data > text choose table(s) >next output file - remove .txt extension choose all fields/records radio buttons >ok Field delimiter, remove the " - field should be empty Field separator, remove comma, enter the pipe, click OK. Output will be created in the start in directory

share|improve this answer
Hmmm... sounds like this thing has a gui. Unfortunately, I'm on a Linux system. Is there a command line equivalent? – Jeremy Holovacs Feb 16 '12 at 20:29
Digging in old posts here... But there's actually a gui even if your on a command prompt. A character based gui that mimics the looks of the graphical Data Admin tool. The binary you should be looking for is INSTALLPATH/bin/pro. In the Tools menu you will find Data Administration. (The menu is usually accessed with the F3-key). – Jensd Jul 23 '13 at 11:52

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.