extracting data from Progress

[nata]

Hi,

my boss asked me to extract some data from Progress and I am wondering now if dumping the data ( using data administration utility) is the only way to do that. I do not want all data from the table but just certain columns.The data has to be exported into a fixed record length flat file and can be in either one of the following format:
Excel
- DBF
- Access
- Tab delimited file
- CSV
Is something like that possible ?
Environment:NT/Progress V 8.3

Thanks in advance,
Nata

 

[wbenhart]

Depending on what you are trying to do, this may help you get strated:

define stream coitem-strem.

output stream coitem-strem to "c:\temp\exp-coitem.csv".

export stream
coitem-strem delimiter ","
"CO Number"
"CO Line"
"Stat"
"Item"
"Item Description"
"Quantity Ordered".

for each coitem where coitem.co-num = co.co-num
and coitem.stat <> "C"
and coitem.stat <> "F"
break by co.co-num:

export stream
coitem-strem delimiter ","
coitem.co-num
coitem.co-line
coitem.stat
coitem.item
coitem-desc
coitem.qty-ordered.
end.

output stream coitem-stream close.


good luck