DSXchange

Moderator: please move to General forum. Welcome aboard. This is not an Information Analyzer question, as one simply does not have the capacity to publish profiling jobs as web services. I don't know the answer to your question - hopefully someone else will - but sometimes you simply do have to cons...

You've done too much, but your answer is still functionally correct.

If it looks like a bug, and smells like a bug...

You can change them, but the values used by your job won't change because they're read into the job processes' memory when the job starts.

So please confirm your reason for wanting to change environment variables or parameter values once the job is running. Then maybe we can look at techniques.

That's not an ETL task - it's a reporting task. Most reporting tools can perform this kind of query.

You will never get parallel jobs to compile or run on version 7.5.1 on Windows.

You must get version 7.5x2 - not 7.5.2 but 7.5x2.

You will also need the DataStage fix pack for Windows XP sp2.

Both are available through your vendor/reseller.

Welcome aboard. Before we can answer that in a cogent fashion, we need to know what version you have installed (exactly) and on what operating system (not just "Windows" but more specific for example Windows Server 2003). The only version 7 version of DataStage that will allow you to compi...

You can't trim before checking for nulls, because the trim functions are intolerant of nulls (this is eased in the next version by the way, because everyone hates it). You just need to re-think the logic. You probably need a two-stage If..Then..Else construct.

Nothing's "going wrong" with Trim function - but you aren't preventing null values of lnk1.C from getting to it. Functions are intolerant of null. Try this: If IsNull(lnk1.A) Then param_DefaultValue Else lnk1.A : ' - ' : lnk1.B : ' - ' : TrimLeadingTrailing(NullToValue(lnk1.C, param_Defaul...

It's probably worth putting the command umask 002 into the $DSHOME/dsenv script, too.

Fabs() is a server job function. It's only available in parallel jobs in the BASIC Transformer stage.

I agree. Do some discovery on how large your job logs are.

And it's not necessarily DB2 - you get the choice of DB2, Oracle or (on Windows only) Microsoft SQL Server.

Something in the job sets user status, probably a routine called from a Transformer stage. Look there.