All Forums Database
SAP 73 posts Joined 08/14
25 Sep 2014
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 ?
 
 
 

SAP
Raja_KT 1246 posts Joined 07/09
25 Sep 2014

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.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

SAP 73 posts Joined 08/14
26 Sep 2014

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

SAP

Raja_KT 1246 posts Joined 07/09
26 Sep 2014

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

sgarlapa 88 posts Joined 03/13
26 Sep 2014

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

You must sign in to leave a comment.