Progress 4; how to export data from "file.DB"? 
Author Message
 Progress 4; how to export data from "file.DB"?

Hi there,
customer got old appl in progress v4, I can run
something called "_progres.exe file.DB". I seems to
understand that but what do I type in here to see
the tables that are in the file.DB?

And how can I export these to external text/data/csv/whatever files??

should be an easy question for an knowledgeable!

Any help appreciated!
Huibert.



Fri, 01 Jul 2005 17:06:26 GMT
 Progress 4; how to export data from "file.DB"?


Quote:

> Hi there,
> customer got old appl in progress v4, I can run
> something called "_progres.exe file.DB". I seems to
> understand that but what do I type in here to see
> the tables that are in the file.DB?

> And how can I export these to external text/data/csv/whatever files??

> should be an easy question for an knowledgeable!

> Any help appreciated!
> Huibert.

If you have a developers license, then the following should show you the
tables in the database:

for each _File no-lock where _File-Number GT 0:
display _File-Name.

If not, then you need to use the dictionary tool to "dump" the data.. Or
look in $DLC/src (I think Progress shipped code in those days) for something
like dump_d.p or _dmpdata.p (which is what it is in V9) and run _progres
file.DB -p _dmpdata.p ("all") - You'll have to check the source for the
exact syntax..

HTH

Kevin



Sat, 02 Jul 2005 16:39:00 GMT
 Progress 4; how to export data from "file.DB"?
Quote:
> > Hi there,
> > customer got old appl in progress v4, I can run
> > something called "_progres.exe file.DB". I seems to
> > understand that but what do I type in here to see
> > the tables that are in the file.DB?
> > And how can I export these to external text/data/csv/whatever files??

> > should be an easy question for an knowledgeable!

> > Any help appreciated!
> > Huibert.

> If you have a developers license, then the following should show you the
> tables in the database:

> for each _File no-lock where _File-Number GT 0:
> display _File-Name.

Ha, great tip. This one worked.
Hmm, now tracking the programme that could export a table.
Seen that one somewhere. Lost it only, but should find it.

Quote:
> HTH

> Kevin

Rgds., Huibert ;-))


Sun, 03 Jul 2005 19:08:32 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Exporting text file "problem/limitation"?

2. File "Import | Export" Menu options

3. max of ("...","...","..")

4. "DTS Export data" error

5. "db file scattered read" and "db file sequential read" wait events

6. Export problem: "0 rows exported"..

7. "db."-file damaged!!!

8. No ,"", on NULL field in db.Text file

9. Update on "vanishing DB-file" situations

10. Importing Data From Adobe "FDF" file

11. exporting "Money Counts" files into "Peachtree"


 
Powered by phpBB® Forum Software