Want to know about OLE_LOAD tool...its urgent

Tools

Want to know about OLE_LOAD tool...its urgent

Hi All,

I want know about OLE_LOAD tool of teradata.
How i can configure this tool according to my requirement of export data from teradata to csv files.

Regards,
Dinesh
2 REPLIES

Re: Want to know about OLE_LOAD tool...its urgent

Hi

Well OleLoad is Used to Move the data from one Table in one TD Box to the Same table in different box. you have to install Teradata Client Utilities for that. its god tool to move Small tables (Less than 10K Records) but for big tables i dont suggest it instead try to use unix fastexport and fastload Script to do that.

You have to cast timestamp to char(19) just incase you have any of them

Regards
Abhijit
N/A

Re: Want to know about OLE_LOAD tool...its urgent

The tool interfaces the FastExport/FastImport and MultiLoad tools to Windows OLE. This will let you for example perform a FastLoad from Microsoft Access to Teradata and back. One side of the load must be to Teradata and the other side to an OLE connection. You can make a connection to Teradata and an OLE/ODBC connection to Teradata as well.

OLE is not well suited for use with text files, by the time you define the file you might have well used one of the other utilities directly.