I got answer to both the questions. Actually jobs which were missed out through above command were not compiled; I would rather say they were never compiled. Once these jobs were compiled I was able to see the results.
This again doesn't solve my primary objective ; at least I have an answer to my questions.
I can achieve the result by running UV command on the Sever side; but first I was exploring for options available on the Client side. Do let me know if anyone has a solution.
!DirDSBin!dssh COMO ON !FicSortie!
!DirDSBin!dssh SELECT !CommandeDS!
move !FicSortie! %DirSauve%\!FicSortie!
set FicResultat=Repository_!Projet!.csv
for /F "skip=3" %%B in (%DirSauve%\!FicSortie!) do (
set LigneLue=%%B
if !LigneLue! neq "SQL+" (
if !LigneLue! neq "" (
if !LigneLue:~0,8!=="Job name" (
set ComposeLigne=!ComposeLigne!;!LigneLue:~9,80!
)
if !LigneLue:~0,8!=="Category" (
set ComposeLigne=!LigneLue:~9,80!
)
if !ComposeLigne! neq "" (
echo !ComposeLigne! >> %DirSauve%\!FicResultat!
set ComposeLigne=
)
)
)
)
...
where
- FicSortie is an intermedary file,
- CommandeDS is "NAME FMT'80L', CATEGORY FMT'80L' FROM DS_JOBS WHERE NAME NOT LIKE '\%%' [AND CATEGORY LIKE 'xxx%'] ORDER BY CATEGORY, NAME
My variable names are "in french" because I am "in France".
I did not translate them, I'm sorry.
But you can find good dictionnaries to do that on the web.
!DirDSBin!dssh COMO ON !FicSortie!
!DirDSBin!dssh SELECT !CommandeDS!
move !FicSortie! %DirSauve%\!FicSortie!
set FicResultat=Repository_!Projet!.csv
for /F "skip=3" %%B in (%DirSauve%\!FicSortie!) do (
set LigneLue=%%B
if !LigneLue! neq "SQL+" (
if !LigneLue! neq "" (
if !LigneLue:~0,8!=="Job name" (
set ComposeLigne=!ComposeLigne!;!LigneLue:~9,80!
)
if !LigneLue:~0,8!=="Category" (
set ComposeLigne=!LigneLue:~9,80!
)
if !ComposeLigne! neq "" (
echo !ComposeLigne! >> %DirSauve%\!FicResultat!
set ComposeLigne=
)
)
)
)
Sorry I am not really sure how to implement this batch file.. is it a windows batch file? I tried to search for 'batch file' and I get six pages of results...