Retrieving Data on a Unix box running 8.2C

K

kashwmu

New Member
My problem is that I have minimal unix experience and almost no progress experience so most of these questions will sound very novice:
1. How can I connect to the server, does ODBC work? if so where can I download the drivers?
2. how can i export the data and in what format?
3. Is there a simple command to view the table names and sizes?

I will start with those questions and hopefully someone can help. Any help is very greatly appreciated!
 
1. You dont need ODBC if you simply plan to dump your data as is obvious from your post. On unix run pro <yourDBname> -p dict.p . You should see data dictionary.

2.The easiest way to dump data is by using the data dictionary you see by running the above command and go to '"admin" and first dump schema ie yourDBname.df and the data file ie yourDBname.d Both the files are in ASCII format.

3.On unix run proutil <yourDBname> -C tabanalys > yourdbname.txt
 
You must log in or register to reply here.
Back
Top