Exporting data from a Progress 9 database to a delimited file

[jacowess]

Hi

Does anyone know how I can export a progress 9 database to a delimited file other than using the ODBC driver?

 

[Lee Curzon]

You can do it through the 4GL (eg. EXPORT statement).

Easiest though is:
Data Admin > Admin > Export Data.

I suspect that may not be an option if you're still having the same problems as before.

 

[jacowess]

Thanks, I am able to connect now.
When I open the data dictionary it states that it is read only because of the version of Progress that I am using, do you know how I get around this?
In Data Admin the Admin menu is greyed out so I cannot get to the export function.

Thanks

 

[Lee Curzon]

What licenses do you have?

Progress config file progress.cfg, eg. Start > All Programs > Progress > Config

(Needs checking Client and Server side, if you are connecting to the database from a client)

In the meantime, have a look at this also.

KB P6673
Title: "Data Administration/Dictionary access w/Runtime or Database Only"

http://tinyurl.com/89l53

Lee

 

[Lee Curzon]

Thanks, I am able to connect now.
When I open the data dictionary it states that it is read only because of the version of Progress that I am using, do you know how I get around this?

Can you access the procedure editor?

Tools > Procedure editor.

If so, see if you can run the folowing code (lifted with modifications from the EXPORT Help entry):

(Change 'customer' to the name of the table you want to read, and 'customer.d' to the name of a file you want to output to).

OUTPUT TO customer.d.
FOR EACH customer NO-LOCK:
EXPORT customer.
END.

OUTPUT CLOSE.

 

[jacowess]

Thanks, I guess I do not have the right license.
I only have a license for WorkGroup Database and Report Builder.

Thanks

 

[Lee Curzon]

Thanks, I guess I do not have the right license.
I only have a license for WorkGroup Database and Report Builder.

Thanks

Try connecting with -rx, and try again. This may only allow access to definitions though, I haven't tried it.

 

[jacowess]

I get the same problem where I dont have a license to compile. I will have to purchase a license it seems.
Thanks for your help.

Regards,