concatenate job log info

VasanthRM · Post by **VasanthRM** » Thu Jun 16, 2005 7:23 am

Hi,
Just went through the postings in DSxchange with regard to Job logs. I am just a beginner.

I was able to find the log details in table RT_LOGxxx
xxx job number.

Is all these logs info present in the universe DB? If so how do I retrieve them using a DS Job?

I tried using a Universe stage. But the table definition does not hold the log tables. To configure what credentials should I need to mention in .odbc.ini file.

Thanks in advance

ArndW · Post by **ArndW** » Thu Jun 16, 2005 7:49 am

Hello VasnathRM,

accessing the internal tables is not a good idea, as the structure is not officially documented and are subject to being changed in the next release. I would recommend against looking at these tables directly.

If you look up information on the external program dsjob it will let you choose from various options to put the log information to stdout. This is the easiest way to see log information from outside of the DataStage environment.

The DataStage routines such as DSGetLogInfo() can give you very specific detailed information, but they do require a bit of familiarity with the UV/BASIC and DataStage environment.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2005 9:31 pm

Go to Director. Select your job. Go to the Project menu, choose Print. Check the Print to File check box.