DSXchange

Lots of code posted which does the same. What do want to do with it?

Post the format and an example.

42

Hash files and sequential files can be listed from DS_JOBOBJECTS. Do a search. The other you need MetaStage, Reporting Assistant or DwNav.

Usually job designs disappear only when you run out of disk space and corrupt the repository.

Download EtlStats from my tips page.

Craig You are correct. This is used to meet some kind of standards. Mainly mine. I do like the fact that the parameters are ll named. I also like that the source and target tables are listed but that means you have to manually update the long description. I agree with Vincent but we always use an an...

It will look something like this: Job: KgdCopyParamJob ------------------------------------------------------------------------------------- Non-technical description: Change DSN from DSNParamName, UserParamName, PwdParamName in FromJobName to ToJobName only if DSN2Change = "value". The id...

I posted a routine called KgdFixLongDesc. It is also on my tips page. You need to modify it to meet your needs. There is another one for routines called KgdFixLongDescRtn. You need to write a job to select all jobs and feed them to this routine one at a time.

I posted a routine that does this called KgdDebugMetadata. I think it is also on my tips page. The sequential file needs to be small because it reads it into a variable. It could be changed to readseq if you want. If you can figure it out then use it.

Edit your post and put code tags around it.

I think the issue is what information you want from these documents. Google can index anything in these documents. Until you know what structured data you want then you have no starting point. There has to be something that needs to end up in a data warehouse table that someone thinks is valuable be...

Define output. Are you talking logs?

You have to make the SQL all one line if you do it this way. The results can be copied with normal Windows cut and paste commands.

Do a search on TCL commands and telnet.