Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Sep 2004 @ 20:37:42 GMT


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


Subj:   Multiload error when spaces in pathname
 
From:   Nick Druga

Assume I have no choice but to store upload files in the C:\Documents and Settings directory. When Multiload reaches the first space in the pathname, it gives an error.

The old way when stored under C:\test (works):

     /* SPECIFY IMPORT FILE AND APPLY PARAMETERS */
     .IMPORT INFILE C:\test\test.txt
       FORMAT TEXT
       LAYOUT FILEIN
       APPLY  INSERTS;

The new way (none work):

     .IMPORT INFILE  C:\Documents and Settings\test.txt
     .IMPORT INFILE "C:\Documents and Settings\test.txt"
     .IMPORT INFILE �C:\Documents and Settings\test.txt�

I even tried the native Msdos representation (no good):

     .IMPORT INFILE  C:\DOCUME~1\test.txt

Any suggestions?



     
  <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