All Forums Tools
brindamaiti 11 posts Joined 10/11
15 Nov 2011
Locatio of output file

Hello,

      I am trying to write a tera data Fastexport script. Can the output file be placed on another server. If yes, then how to specify the location on the new server and how to specify the authentication .

Thanks.

Best regards,

brinda

SuSeSi 61 posts Joined 10/08
23 Nov 2011

You can write a wapper script which can mount a server location in your fastexport executed system, give proper permission. Or you can generate it, ftp it to server and delete from local system.

-Sudhansu

room.hunter77 5 posts Joined 02/12
22 Feb 2012

How do i get teradata to run ftp or a similar command from the server ?

ulrich 816 posts Joined 09/09
22 Feb 2012

I am not sure if you really want this to be done from the TD server.

I would expect to do this much more on the load utlities client machines.

But if TD should do this check the external stored procedures. manuals -> SQL Refernence -> External Routine Programming

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Stefans 38 posts Joined 02/12
22 Feb 2012

In Mainframe system you can export the data to a PS file by invoking the FXPORT utility.This also requires another step in the same JCL to invoke the XCOM utility which shall transfer the mainframe file to specified location of the destination server in desired format(say txt).

Stalin

brindamaiti 11 posts Joined 10/11
11 Apr 2012

Thanks for all your replies.

You must sign in to leave a comment.