Archives of the TeradataForum

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

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

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>>