DSXchange

chulett wrote:Yin and Yang, eh? Better than Eng and Chang, I suppose.

Dennis, Walter, Andy, et al. - Let me echo everything Kim has said. Thanks for letting us be a part of this!

Nice. Can I steal this image for a logo?

I think you want read uncommitted but I need to look it up. Sometimes you can do it in user defined SQL with a NOLOCK or whatever the database needs based on syntax.

Leave me and my logo alone.

Humble, I like it.

Dennis Thanks for 10 years of a great company and thanks again for supporting and creating this web site. The DataStage community thanks you as well. This forum thanks you as well. We would of never met Ray and Criag, the Yin and Yang of DataStage. Thanks to your crew too, Walter, Andy and anyone el...

Craig is answering old posts? Need the points then you should not ask Ray a question.

If you do this then you might lock the records you are trying to update. So the source SQL needs to have the correct options on it.

You like the smaller version?

Ray is correct. The result for a job might be 50.1.0 which would indicate version 1.

dscc is the command line compile tool. Search for it.

One of the tables in EtlStats is ETL_PARAM_HIST. This gets loaded along with the other tables. There is a job which can extract these values from previous job runs in the log files as long as there are not cleared.

This came from http://www.dsxchange.com/viewtopic.php? ... omPropName

This post is mostly about 3 jobs in EtlStats which extract this data. The stages with Input in the name do the opposite. They output data. So you probably have what you want.

Do not double post. This is a server concept not a PX one.

Try this http://www.dsxchange.com/viewtopic.php? ... light=KDBP

Me too.