Fastload via MS-DOS batch file

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Fastload via MS-DOS batch file

Rate Topic

Display Mode

Topic Options

Author

Message

terakops

Posted 5/11/2007 3:33:44 PM

Junior Member

Group: Forum Members
Last Login: 4/3/2009 1:21:58 AM
Posts: 14, Visits: 31

Hi,

I have created a batch file as-
C:\Program Files\NCR\Teradata Client\Bin\bteq < C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\DDL\School_Master.txt > C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\Logs\SM_DDL.log
C:\Program Files\NCR\Teradata Client\Bin\fastload < C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\FLOAD\School_Master.txt > C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\Logs\SM_FLOAD.log

But this batch does not run. Niether the log files are created.

Can you advise.

Post #7426

joedsilva

Posted 5/14/2007 12:47:39 AM

Supreme Being

Group: Forum Members
Last Login: 7/10/2009 6:28:52 PM
Posts: 505, Visits: 546

my guess is that It may be because of the spaces in your command, so you might have to put things in double quotes. ie

"C:\Program Files\NCR\Teradata Client\Bin\bteq" < "C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\DDL\School_Master.txt" > "C:\Documents and Settings\Indrajit Gaikwad\My Documents\School_Project\Logs\SM_DDL.log"

and so forth...

Post #7433

Farhan

Posted 5/21/2007 2:03:33 AM

Forum Newbie

Group: Forum Members
Last Login: 5/21/2007 2:00:00 AM
Posts: 4, Visits: 1

Add the teradata utilities' directory path in the PATH variable of the DOS and then run these utilities by simply typing c:\> bteq < directory\urfile > directory\logfile. and it will be more helpful if u browse urslef in the directory where u have scripts and then run
c:\ur_directory> bteq < file > log

Farhan Nisar

Post #7537

suhel

Posted 5/28/2007 2:13:01 AM

Forum Newbie

Group: Forum Members
Last Login: 11/12/2009 1:37:49 AM
Posts: 4, Visits: 6

try the path as
c:\docume~1\ ..

like that

$uhel
------
INDIA

Post #7640

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:08pm