Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2004 @ 14:45:09 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Import Data from .csv file to a table using MultiLoad
 
From:   Michael Larkins

Anuradha:

It is telling you that it cannot find the Teradata system. In order to connect across the network, it needs the IP address. The IP address can be obtained by the utilities in one of two ways: a DSN name or tdpid name referenced in the .logon statement:

.logon <tdpid>/<userid>,<password>


Since you have specified no hostname in your logon statement, it is most likely defaulting to dbc. Many people simply go to the HOSTS file and add one or more entries for Teradata.

HOSTS

format:           cop1

examples:   1.0.0.127    myhost1       dbccop1   /*  .logon mike,mikepass  or .logon dbc/mike,mikepass   */
            121.5.23.45  myhost2       testcop1  /*  .logon test/mike,mikepass   */

Hope this helps,

Michael Larkins
Certified Teradata Master



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023