Redirect query resuts to file

Database
N/A

Redirect query resuts to file

Can anyone tell me how to set the result of a query to a file?

In fact what I need is to create a copy of a local database in orther to restore it at my customer's server...

As I know nothing about teradata backup/restore utilities I thought I'd just save the script of each table as well as their data into simple text file and then run the script and upload the information via fastload in the server.

If anyone is patient enough to give me some hint of how to do that, I'd be enormously thankful.

Regards,
Rodrigo.
3 REPLIES
l_k
N/A

Re: Redirect query resuts to file

Hi Rodrigo.

Better you can use the ARCMAIN utility to copy all the local database tables
into the customer's server.

1) Archive all the tables from your local database using ARCHIVE command in arcmain.

2) Then,Copy the RLG file to the customer's server using COPY command in arcmain.

Regards

Lavakumar.
N/A

Re: Redirect query resuts to file

Thank you, very much, Lavakumar.

But there is still a problem: I don't have a clue on how to use Arcmain
=S

Could you help me with that, too?

Tks in advance,
Rodrigo.
N/A

Re: Redirect query resuts to file

(Sorry, I am REALLY beginning...)