Export pipe-delimited data with progress db

dumpprogress-database

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?

Best Answer

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.

Related Question