Spaces in File Pattern Pathname

[ray.wurlod]

Found and solved a curious happenstance today.

Using File Pattern property in Sequential File stage, where a folder in the pathname contained spaces in its pathname, View Data (and job run) returned an incorrect error indicating that no files matching the pattern could be found.

Changing from the long name to the DOS short name provided a solution. For example, instead of "DS Exercise Data" as the folder name, I used "DSEXER~1".

I've also noticed that forward slashes work more reliably in Windows pathnames from DataStage than do backslashes.

To find out the equivalent short name for a folder, use the /X switch with the DIR command in a CMD shell.

Code: Select all

> DIR /x DS*
 Volume in drive C has no label.
 Volume serial number is 880F-1543

 Directory of C:\Training

11/06/2008 01:56 PM  <DIR>   DSEXER~1   DS Exercise Data

[chulett]

Typically, long filenames with spaces in them need to be quoted so the spaces don't confuse things. Is that not another option here?

Thank goodness for still having 8.3 under the covers, though.