DSXchange

Go to the job sequence's job properties, select "Automatically handle activities that fail" and re-compile. Without this set, jobs under control can abort and the sequence finish with an OK status - you have to inspect the job sequence's log to determine the cause. With it checked, and wit...

Ignore what View Data is showing you. Characters 0x00 through 0x0F can be represented by PIC X. These are not printable characters. What did you expect to get?

Create a job that sends 0 rows, but has "clear before write" set. Or has "delete before create" set. If there is a VOC entry for the hashed file you can also use the CLEAR.FILE command (which the first of the above choices does under the covers).

"might be"? Have you measured anything?

Increasing the amount of memory allocated to the Sort stage may help, provided that you have spare memory capacity.

Yes you can. The Monitor lets you show instances and the API functions can return per-instance figures.

Lookup stage wants to find an input column with the same name as the key column on the reference input, it would seem. I'm not in a position to experiment right now. Either what I've written above is correct, which does not really seem likely, or you have not correctly mapped an input column to the ...

Not connected.

Hmm.

There is no such think as Oconv() for a timestamp. Your second argument is completely wrong. You must convert the date and time portions separately then concatenate them.

I've never tried it. Why aren't you sure? Did you get the expected results or not?

There are many other kinds of resource that might be mentioned in a parallel execution configuration file. However, to address the specific question that you asked, the disk resource specifies, for the particular node, where that portion of a Data Set or File Set that contains records for its partit...

There is a Checksum stage in version 8.1.

There will be a webinar on this very topic on DSXchange Learning Center in the very near future. It was recorded last week and is presently being edited into downloadable format.

Your question is extremely vague. Is it an interview question? There are two kinds of shared container that can be used in a parallel job - which kind do you mean?

Use Monitor view in Director client. Right click on the background and choose "Show CPU" from the menu. This displays CPU usage as a percentage of available CPU capacity. CPU can also be had using the DataStage API, in particular DSGetJobInfo() function, in which case it reports raw CPU co...

I doubt it, because U is currently working on a server-only site. The second person personal pronoun in English is spelled "you". There are scripts supplied for creating the common repository in Oracle or SQL Server, and these scripts are documented in the installation notes and manual. I ...