DSXchange

DS_AUDIT has been explained in several posts by Ray. EtlStats includes about 60 scripts most report on these tables like DS_JOBS and DS_JOBOBJECTS but a few also look at RT_LOG and RT_STATUS. There are lots of jobs included which extract this information to create your own metadata repository. These...

Do an exact search for EtlStats.

KgdGenHtmlRoutineDocs is a part of GenHtml which you can download from my tips page. It documents almost every field in DS_ROUTINES by reading them and generating html documents for one or all the routines in a project.

Is this true for UV stages?

Ray, that ain't workin. Playin the sitar on MTV.

I think John is correct. Is your hash file key = 1? How did you get your parameter value in the hash file?

Arnd's way works but are you looking for JOBNO for one job? If so then you need to add a WITH to your SELECT or Arnd's and a WHERE to a SQL SELECT.

SELECT DS_JOBS JOBNO TO 10

Where is your FROM clause? Ray's method needs SLIST to use with SQL SELECT.

That is probably wise. LDAP complicates everything because you can be out of sync on your servers. Local users override LDAP. You need to use LDAP on all servers.

That was my point. It probably just looks funny. If it works and you can view it in a job then don't worry about it.

Index() is your friend too.

Do you have CR, LF or tabs in your data? (char(10), char(13), char(9))

Excellent routine.

Okay, I see what you mean.

http://www.dsxchange.com/viewtopic.php? ... 4&start=15 should help.

I disagree. My code is much easier to read. Parsing the capturing variable from an execute command is very ugly.