2

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?

Jeremy Holovacs
  • 1,271
  • 4
  • 20
  • 27

2 Answers2

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.

Tim Kuehn
  • 221
  • 1
  • 7
1

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

Roger
  • 11
  • 1