DSXchange

I'm surprised it works with Oracle. Parameter markers are not supposed to work in the SELECT clause. The SELECT clause returns columns that exactly match the metadata. Parameter markers in the WHERE clause (and this has to be done on a reference link) are populated with Key Expression values from th...

You can not change a job's parameter values once the job is running. Therefore you will need to read the file before the job runs (for example from an Execute Command activity in a sequence) and use its output, trimmed of field marks, as the value with which to provide the parameter in a downstream ...

No, it has to be done before the lookup. That is, in an upstream Transformer stage.

Restart your client machine and try again, maybe with a different "Save As" name.

It's actually more difficult in version 8, for example because DS_METADATA (which holds table definitions in earlier versions) now holds only category (folder) "pathnames" - the actual table definitions are in the unified metadata repository for Information Server. The easiest way is proba...

I'm sure I answered that recently in a different thread. Too busy to search for it at the moment. Solution involved use of Job1 user status area.

Indeed that's the full list for version 7. However you may have configured that the DataStage deadlock daemon (dsdlockd.exe) runs; it's probably worth including that in your anti-virus "white list" as well.

Please mark this thread as Resolved using the green button at top.

Interesting - the manual (Orchestrate Operators) clearly specifies single quotes. Thank you for responding, and persevering (obviously Frequency field is source data and therefore, presumably, impermissible to change).

My first guess is that the &PH& directory in the process is becoming more and more full. Clear it out severely - perhaps everything more than two days old.

StripWhiteSpace() is for parallel jobs - it's not missing, it's just that you're not in a parallel job. Trim() has arguments that strip "white space", which includes space characters and tabs, from various parts of the string. If NLS is enabled, then trimmable characters are set in the CHA...

In Job 1 load both, separated by some convenient character such as tab, into the job's user status area.

In the job sequence retrieve Job1's user status area and decode into the two parameter expressions for Job2.

venkates.dw wrote:i want to find each job process id , those are running in batch job..

Why? You'll just go and kill them.

Yes, I could, but no more lucently than the on-line help and manuals do. An Exception Handler is an activity you can use in a job sequence. The compile option "automatically handle activities that fail" lets you handle failures of other activities in three ways. Tune in to tomorrow's Webin...

Have you checked the compiler option "automatically handle activities that fail"? Do you have an Exception Handler in your sequence? Do you understand how to manage failure in sequences?