DSXchange

No it's still not clear. Your code seems to want to do something with the parameter name. Your example does not. I believe your required algorithm is "for each parameter name found in InString substitute the parameter reference (that is, the name surrounded by sharp signs) with the parameter va...

Well, you're convinced. Convince them.

Can you please provide an example of InString and the expected output if this value were to be processed by the routine?

Have your DBA check for deadlocks and lock waits in the database.

Uncheck the "automatically generate warnings" option in Job Properties.

Is it possible to obtain the data in delimited format?

You could use the Index() function to check for each individual word. This would require hard coding "search file II" into your design.
You could parse the strings into separate rows with one word plus the account number per row (a pivot), and use a regular lookup.

ajrandrup wrote:Has anyone ever encountered an instance where a user updates the DSParams via DS Administrator, but when checking DSParams file on the Unix folder, some variables get missing?

Not me.

Create explicit triggers (custom triggers) to handle the explicit exit status values plus - if needed - an Otherwise trigger to handle unexpected values.

Don't try to find a solution using Modify stage. Use Transformer stage.

Is this a QualityStage job? That is, does it use any of the Data Quality stage types? If so, have you provisioned all the files for the rule set that you are using?

Transformer stage is best for identifying which particular field (or fields) contain changes. The three stage types you mentioned only report that a change exists in the record (though in one case the "direction" of that change, larger/smaller, can also be reported taking the record as a s...

Go back, read all the advice carefully. Everything you need to do is already in this thread.

You can always use Entire partitioning.

From memory, in version 7 job run requests pick up the user ID under which the DataStage services, particularly dsrpcd, were started. Are you running in "impersonation mode"?