Data Stage Report
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Thu Mar 20, 2008 12:11 am
Data Stage Report
We can generate in JOB level from job properties in DS parallal job.
But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file
and another thing is it possible to give user defined report name ? other than generating system define name like jobname_timestamp.
Please give details
But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file
and another thing is it possible to give user defined report name ? other than generating system define name like jobname_timestamp.
Please give details
nsd
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 59
- Joined: Thu Mar 20, 2008 12:11 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not intending to answer instead expanding the question to reach the extreme of our need.
1.
2.
1.
Can we have any customization in the default(or other if chosen) XSL Stylesheet to get Job report for the Job Sequence and the Job Report for the Jobs, which are configured inside the Job Sequence, in the same Job Sequence Reporting folder. (such as - Job Sequence HTML Report, Job Sequence Design BMP file, <Job Report HTML Report, Job Design BMP file>,...)?das_nirmalya wrote:But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file
2.
I am sure enough to note that this can be accomplished by taking the Job Report through Command line. I wonder why there are no options in the GUI Job reporting tool to obtain such options - User defined Job Report Name, Include Job Design BMP file, Job Report format(XML/HTML)?and another thing is it possible to give user defined report name ? other than generating system define name like jobname_timestamp.
-
- Participant
- Posts: 59
- Joined: Thu Mar 20, 2008 12:11 am
Re: Data Stage Report
I want to create Log file in sequence level , so that when seq run , it will generate the log file automatically for individual jobs those are embeded in Sequencedas_nirmalya wrote:We can generate in JOB level from job properties in DS parallal job.
But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file
and another thing is it possible to give user defined report name ? other than generating system define name like jobname_timestamp.
Please give details
nsd
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do we have answers for these questions?
ag_ram wrote: 1.Can we have any customization in the default(or other if chosen) XSL Stylesheet to get Job report for the Job Sequence and the Job Report for the Jobs, which are configured inside the Job Sequence, in the same Job Sequence Reporting folder. (such as - Job Sequence HTML Report, Job Sequence Design BMP file, <Job Report HTML Report, Job Design BMP file>,...)?das_nirmalya wrote:But i want to generate the report in Sequence level, if seq contain 2 job then report should contain details of 2 jobs in a single log file
2.I am sure enough to note that this can be accomplished by taking the Job Report through Command line. I wonder why there are no options in the GUI Job reporting tool to obtain such options - User defined Job Report Name, Include Job Design BMP file, Job Report format(XML/HTML)?and another thing is it possible to give user defined report name ? other than generating system define name like jobname_timestamp.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please don't overquote. It's a waste of space on the server. Everything needed already exists in the thread.
The answer to question 1 is "Yes". Question 2 is rhetorical (I wonder why...).
The answer to question 1 is "Yes". Question 2 is rhetorical (I wonder why...).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Open the Designer and click the Job Report tool (the one that looks like an Internet Explorer icon). You can create your own stylesheets to govern the format of the reports thus produced.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod,
Till i have focussed on 'Job Reports', the answer to my question is NO. Because
DataStage Job reporting facility does not indeed generate HTML report but generates an XML report initially to which, the mentioned XSLT Stylesheet applied to convert to HTML to be suitable for viewing in a brower(perhaps Internet Explorer 6.0 for best view). And this intermediate XML report would be deleted after conveting it to HTML Report but would be retained, if desired to look at [External option]. If there is any need to modify(format) the converted HTML Report, all user defined customizations would be made to default XSLT Stylesheet(or new custom XSLT Stylesheet) with a proper consideration of generated XML Report. Most important that the customized XSLT Stylesheet does not guarentee that such customizations made inside would result to generating Job Reports individiually for all Jobs configured to be run in a Job Sequence.
Please correct me if i am wrong.
Till i have focussed on 'Job Reports', the answer to my question is NO. Because
DataStage Job reporting facility does not indeed generate HTML report but generates an XML report initially to which, the mentioned XSLT Stylesheet applied to convert to HTML to be suitable for viewing in a brower(perhaps Internet Explorer 6.0 for best view). And this intermediate XML report would be deleted after conveting it to HTML Report but would be retained, if desired to look at [External option]. If there is any need to modify(format) the converted HTML Report, all user defined customizations would be made to default XSLT Stylesheet(or new custom XSLT Stylesheet) with a proper consideration of generated XML Report. Most important that the customized XSLT Stylesheet does not guarentee that such customizations made inside would result to generating Job Reports individiually for all Jobs configured to be run in a Job Sequence.
Please correct me if i am wrong.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sure... in the words from DataStage Release 7.5 Developer's Help pages
Hope now you could correct me if i am anyway wrong.
Most important that the customized XSLT Stylesheet does not guarentee that such customizations made inside would result to generating Job Reports individiually for all Jobs configured to be run in a Job Sequence.DataStage Release 7.5 Developer's Help wrote: ...(the report is initially generated in XML, the stylesheet converts it to HTML, suitable for viewing in a browser). You can also define a custom stylesheet for this purpose, in which case choose User defined stylesheet and type in, or browse for, the pathname of your stylesheet....
...Select Retain intermediate XML file to prevent DataStage deleting the intermediate file it generates. You will need to look at this file if you want to define your own XSLT stylesheet...
Hope now you could correct me if i am anyway wrong.