I am compiling DataStage Jobs and Folder through dscc command, through a batch file. My DataStage Folder name contains space in between names. For example, one of the folder name is "00 Sequence". When there is a space in names, dscc command fails. Can any of you suggest me how to use the command when there is a space. Following is the command
Double-quotes are the right answer, that or the 8.3 original short name that's still there. Try "\Jobs\TEST\00 SAMPLE\"* instead, that or \Jobs\TEST\00SAMP~1\* as a guess. Note the number at the end may be different depending on 'duplicates'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
SET DsBaseDir=C:\Progra~1\Ascential\DataStage7.5.1
SET DsCompileCmd=%DsBaseDir%\dscc.exe
%DsCompileCmd% /h %ImportHost% /u %ImportUser% /p %ImportPassword% %ImportProject% /j %%i /f >> %LogFileName%
This is obviously older version of DataStage but all you need to do is add the domain info. The compile command is in a loop where it is exporting one job at a time and importing it then compiling it. So "%%i" is fed from that loop. You can easily build a list of jobs with dsjob command but not based on a folder. The folder name is not easily obtained.