Generating an XML report

• DSMakeJobReport API function (see DSMakeJobReport)
• DSMakeJobReport BASIC function (see DSMakeJobReport)
• dsjob command (see Generating a report)

InfoSphere® DataStage® provides the following files to assist in the handling of generated XML reports:

• DSReportSchema.xsd. An XML schema document that fully describes the structure of the XML job report documents.
• DSReport-Monitor.xsl. An example XSLT stylesheet that creates an HTML web page similar to the Director Monitor view from the XML report.
• DSReport-Waterfall.xsl. An example XSLT stylesheet that creates an HTML web page showing a waterfall report describing how data flowed between all the processes in the job from the XML report.

The files are all located in the InfoSphere DataStage client directory (\IBM\InformationServer\Clients\Classic).

You can embed a reference to a stylesheet when you create the report using any of the commands listed above. After the report is generated you can view it in an Internet browser.

Alternatively you can use an xslt processor such as saxon or msxsl to convert an already generated report. For example:

java - jar saxon.jar jobreport.xml DSReport-Monitor.xsl > jobmonitor.htm

would generate an HTML file called jobmonitor.htm from the report jobreport.xml, while:

msxsl jobreport.xml DSReport-Waterfall.xsl > jobwaterfall.htm

would generate an HTML file called jobwaterfall.htm from the report jobreport.xml.