Could somebody point me to a resource where i can find something on how to automate/schedule a periodical export from a Progress 7 database tables to ascii files in unix....? I have accsess to tools like Result and procedure builder and database schema. I am new to progress and i know very little on Progress. Although i have experience in using some other databases like oracle and sqlserver.
It would be a life saving work if somebody point to something, quickly. thanks in advance
nilesh
"nilesh" wrote:
>
>Could somebody point me to a resource where i can find
>something on how to automate/schedule a periodical export
>from a Progress 7 database tables to ascii files in unix....?
>I have accsess to tools like Result and procedure builder
>and database schema. I am new to progress and i know
>very little on Progress. Although i have experience in
>using some other databases like oracle and sqlserver.
>It would be a life saving work if somebody point to something,
>quickly. thanks in advance
>
>nilesh
Nilesh:
The right way to create an ASCII file is using a stream. Like:
DEF STREAM si-dhl-data.
DEF STREAM so-error.
DEF STREAM so-unscan.
....
OUTPUT STREAM so-emcon TO value(mt-emcon) NO-ECHO.
OUTPUT STREAM so-error TO VALUE(mt-error) NO-ECHO.
OUTPUT STREAM so-unscan TO VALUE(mt-unscanned) NO-ECHO.
.......
PUT STREAM so-error
...
At the end, don't forget to close the stream(s):
...
OUTPUT STREAM so-emcon CLOSE.
OUTPUT STREAM so-error CLOSE.
OUTPUT STREAM so-unscan CLOSE.
Hi Nilesh,
You can use the Progress export-statement.
Example:
OUTPUT TO cust.d.
FOR EACH Customer:
export Customer.
END.
OUTPUT CLOSE.
This creates a space-delimited file. Each field is put inside double quotes.
You can use the crontab feature of unix to start Progress with this procedure periodically.
Rabien
thanks, Louis and Rabien ,
I am working my way through the manuals. I think I will need to define frame and use it in some sort of for loop. I would think that mbpro is the backgroud batch processing utility i will have to use.
nilesh
"nilesh" wrote:
>
>Could somebody point me to a resource where i can find
>something on how to automate/schedule a periodical export
>from a Progress 7 database tables to ascii files in unix....?
>I have accsess to tools like Result and procedure builder
>and database schema. I am new to progress and i know
>very little on Progress. Although i have experience in
>using some other databases like oracle and sqlserver.
>It would be a life saving work if somebody point to something,
>quickly. thanks in advance
>
>nilesh