Spaces in File name in Fastload

Database
Fan

Spaces in File name in Fastload

Hi all,

 

I am new to Teradata Fastload and have created a fastload script.

 

The file path to my data file contains spaces in it. I have surrounded the file path with " " and I get an error message saying "Cannot Open file".

 

I can see that it doesn't correctly point to the file path and stops when it encounters the first space in the path to the file.

 

Can someone please tell me how to resolve this?

 

Many thanks

3 REPLIES
Teradata Employee

Re: Spaces in File name in Fastload

Try using single quotes (') instead of double quotes (").  If that doesn't work, also try escaping the space(s) by preceding it (them) with a backslash (\).

Fan

Re: Spaces in File name in Fastload

Hi there,

 

Thanks for your reply. I tried a single quote and a preceding all the spaces with a backslash (\) and it didn't work.

 

Any other ideas would be appreciated.

 

 

Thanks

Teradata Employee

Re: Spaces in File name in Fastload

could you please post an actual example of you code for review? thx, dave