DSXchange

You have to tell DataStage what value in the file (in each field, if the fields are of different widths) represent null. This is typically achieved through the Null Field Value property. Search the forum, consult on-line help, or read the Parallel Job Developer's Guide to learn how to set this prope...

Welcome aboard. It this a transient problem, or is it reliably reproducible? Mutex locks are how semaphores are implemented on HP-UX, and the lock tables in DataStage are implemented as semaphore sets, which is why you are seeing issues with mutex locks. As to what's causing them, this is possibly m...

Of course pretty much any default behaviour in DataStage BASIC can be overridden by $OPTIONS compiler directives.

In this case, to have the -1 element add a new empty field/value/subvalue, specify $OPTIONS EXTRA.DELIM (or, if you're lazy or a bad typist, $OPTIONS W).

This is not a DataStage problem.

Your Oracle instance has run out of space in your TEMP01 tablespace. Either clean up (drop) some old tables or have your Oracle DBA extend the TEMP01 tablespace.

Provisioning is the step of moving your QualityStage jobs and stages (and rule sets, as necessary) from the Designer to the server.

Have you done this?

You need numbered parameter markers for Oracle.

If the Lookup (and any other) stages are adjacent, use the same degree of parallelism and combinable, then their operators will be combined into one process. Therefore the answer to you question is likely to be "no".

Check that the partitioning is correct. Each key (combination of key columns) must occur on one processing node only.

It IS common practice that integers are right justified, sometimes left padded with space, sometimes left padded with zeroes.

You can handle it easily with Trim().

No.

Type 2 SCD relies upon surrogate key to preserve history when the meaning of a business key changes.

There's no such thing as a DataStage user - you simply add them as UNIX users and make sure that they're in the correct group for DataStage and the correct group for each project in which they're expected to work. Each UNIX has its own commands for adding users and groups. For example on AIX you'd u...

The same chapter is repeated in Parallel Job Advanced Developer's Guide - I note that your job type is marked as parallel.

You can use attachments (up to 5MB, if my memory serves) at IBM DeveloperWorks.

Both sites are planning upload/download capability. Issues relating to viruses, spam and the like are still being worked through: probably some form of moderated area will be implemented.

The -lstages option lists the stages in a job, not information about a particular stage. You probably need the -stageinfo option.

Start by finding the Connector stage, select it and open help (F1 will do). You can also read the manuals (found here if you don't have them convenient).