generate HTML report in datastage
Moderators: chulett, rschirm, roy
So I did a search of DSXchange , downloaded Kim's utilities, and edited DsJobReport.bat for my local environment.
Questions:
1) Does dsdesign.exe tolerate long file paths as long as they are properly quoted? After editing Kim's batch file, here is my command line:
dsdesign is complaining about the RP path, but I can't see anything wrong with it, and it's properly quoted as a long path containing spaces.
2) Our jobs are promoted to TST and UAT as readonly. Is there any way to suppress the "'MyJob' is Read Only. Any changes you make cannot be saved" dialog window? I'm just trying to create a job report, and don't want to click "OK" on hundreds of dialog windows.
Thanks,
Scott
Questions:
1) Does dsdesign.exe tolerate long file paths as long as they are properly quoted? After editing Kim's batch file, here is my command line:
Code: Select all
"C:\Program Files\Ascential\DataStage7.5.1\dsdesign.exe" /H=myhost /U=myuserid /P=mypassword UAT_MyProject MyJob /R
/RP="C:\Documents and Settings\sbass1\Desktop\My Documents\My Documents\MyProject\Documentation\Job_Reports\UAT_MyProjec\"
2) Our jobs are promoted to TST and UAT as readonly. Is there any way to suppress the "'MyJob' is Read Only. Any changes you make cannot be saved" dialog window? I'm just trying to create a job report, and don't want to click "OK" on hundreds of dialog windows.
Thanks,
Scott
Some people are the Michael Jordan's of Datastage. I'm more like Muggsy Bogues
1) It should work fine with them, as noted. Are you sure it should have "My Documents" twice in the pathname? The other thing is to go back to the "8.3" short file name for the problematic pieces. For example "My Documents" is probably "MyDocu~1".
2. I've never actually run it outside of dev, thus not against read-only jobs. It pops up that dialogue box every time you run dsdesign.exe from the command line?
2. I've never actually run it outside of dev, thus not against read-only jobs. It pops up that dialogue box every time you run dsdesign.exe from the command line?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks Craig. As always, much appreciated.
1) Yes, the double "My Documents" is correct. I put a lot of stuff under "My Documents", including "My Documents" So it's a directory I created. I'm sure the path is correct - if I find dsdesign.exe doesn't handle quoted long path names, I'll either use short names or change it to C:\Temp or somesuch.
2) <rant> Grrrrrr...who DOES the usability testing on this product? Ah, ok, I feel better now </rant>
Ok, I'll have to hack Kim's batch file (like break it into two parts) to get the list of jobs from UAT but generate the job report from DEV. We have hundreds (??? - well, a lot) of test/junk jobs in DEV I wouldn't want printed.
But it would be real nice if dsdesign would just ignore the readonly attribute when generating a job report from the command line.
1) Yes, the double "My Documents" is correct. I put a lot of stuff under "My Documents", including "My Documents" So it's a directory I created. I'm sure the path is correct - if I find dsdesign.exe doesn't handle quoted long path names, I'll either use short names or change it to C:\Temp or somesuch.
2) <rant> Grrrrrr...who DOES the usability testing on this product? Ah, ok, I feel better now </rant>
Ok, I'll have to hack Kim's batch file (like break it into two parts) to get the list of jobs from UAT but generate the job report from DEV. We have hundreds (??? - well, a lot) of test/junk jobs in DEV I wouldn't want printed.
But it would be real nice if dsdesign would just ignore the readonly attribute when generating a job report from the command line.
Some people are the Michael Jordan's of Datastage. I'm more like Muggsy Bogues
1) That's been my typical 'solution' as well, I tend to keep output directory names short and near the root, typically right under C:\Temp as well.
2) Ah... know what you mean about the crap inherent in a dev project, that sounds like a practical solution to the problem provided the dev job isn't currently undergoing... improvements.
2) Ah... know what you mean about the crap inherent in a dev project, that sounds like a practical solution to the problem provided the dev job isn't currently undergoing... improvements.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I had the same error recently (v11.3)... Just removed the "" in end of the path in RP...sbass1 wrote:dsdesign is complaining about the RP path, but I can't see anything wrong with it, and it's properly quoted as a long path containing spaces.Code: Select all
"C:\Program Files\Ascential\DataStage7.5.1\dsdesign.exe" /H=myhost /U=myuserid /P=mypassword UAT_MyProject MyJob /R /RP="C:\Documents and Settings\sbass1\Desktop\My Documents\My Documents\MyProject\Documentation\Job_Reports\UAT_MyProjec"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: