Text File to load table

Database
SAP
Enthusiast

Text File to load table

Hi ,

I have to load some [9000 rows] data from SQL server to teradata table . These are options i am left with :-

1. I have TD Studio Express 15 with teradata 14.

2. I dont have UNIX or any other environment to load data

Can i use windows cmd prompt for loading data using MLOAD or FLOAD ?

Tags (1)
4 REPLIES
Enthusiast

Re: Text File to load table

You can use. One way is to write your script in notepad and store somewhere and execute. Make sure you are in the path or you configure path of mload/fload.

SAP
Enthusiast

Re: Text File to load table

Thanks Raja !!! but how to check if loader utilities are installed in my system.

????

Enthusiast

Re: Text File to load table

I m more comfortable in Unix/Linux , using find :). In windows, you can just browse with a mouse and check where Teradata stuff is there.

It can be something like in this link only for the path, example:

http://forums.teradata.com/forum/tools/teradata-parallel-transporter-wizard-14-10-issue

Enthusiast

Re: Text File to load table

A simple way of finding the utilities in our system would be - go to command prompt and type below commnds -

Ex:

C:\Bteq

c:\mload

c:\fastload

c:\fexp  

These command would give the version of the utilities installed. can come out of the utilitiy prompt by pressing ctr+c