DSXchange

All records in DS_JOBOBJECTS are controller or identified by the field OLETYPE. This field really identifies the Windows program which deals with that plugin. You do not really care about how it is implemented normally all you want to do is report on it. The Oracle plugins almost all have OCI in the...

Charles

You need to talk to IBM. They will be glad to sell you WAVES and CASS files. You get monthly and quarterly updates directly from IBM and indirectly from USPS. Works great.

There are lots of examples on this site and on my tips page or on the other link below my signature.

If you tell us specifically what you want then we can supply SQL for those columns to run against the Reporting Assistant tables in doc_tool.mdb or the repository tables. I think I posted update action recently for plugins. It is not easy to get these values out of the repository tables.

Macros are supplied by the vendor in this case IBM. Things like DSJobName and DSHostName are just nice to have. They save time and can be used like any variable.

Good job Ken.

Brad

I have heard of over 2500 fields. That is the largest I have heard of and it took forever to import. I think ODBC may choke on record lengths that long.

Are you sure that one is not a nvarchar?

Craig, here is another tip "horked" is NOT readable.

Part of EtlStats is a job called GenHtmlJobLog. This job will mail you the last run of the log. So take it and modify it to your needs. Source code is included.

Ray, I think the issue is when do you get your stats. I think it should always be a part of of the ETL process and not something after the fact. This information is more useful when it is current. I think Ken and others agree with me.

Ray, what do you think?

EtlStats is free. You can download it on my tips page or the other link below. You can call one job and update several tables with row counts and sequence start and stop times. It takes about 30 minutes to create all the tables and set it up to run on an on-going basis. There is one job to call to g...

The LOGTO does the same as cd MyProjectDir and then list your hashed file. The LOGTO is in a separate shell from the second command because you invoked 2 uvsh commands. You either need to change directories to the project directory and then invoke just the second uvsh or send multiple commands to 1 ...

There is a bug in certain versions of DS where the parameter values are not passed to the script. It shows up correctly in the log but never gets sent to the script.

You need to switch to routine activity if you have this problem then run ExecSH. Works fine.

Please edit your post and put code tags around it so we can see the indentation. Thanks.