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.

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
add comment

2 Answers 2

If you're ok with writing some code:

OUTPUT TO VALUE("filename.d"). 

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

OUTPUT CLOSE.

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

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.