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?
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 (\).
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.