DSXchange

Use Director client. It has a Print option, which has a Print to File option. Director also has a Filter - filter on job status so that you get just the running jobs. in Status view, select "print detail".

Even having the job log open in Director can lead to "may be being monitored".

That's a very easy one. It can't be done with this tool. DataStage is driven by the metadata, not the reverse. Some people elect to create a "generic table definition" with more than enough VarChar columns, but it's not really a satisfactory solution.

You're on the bleeding edge of the technology there, using the C API to create a project. I doubt that many folks have done what you're trying to achieve. There's got to be some property you can set, which is likely to be described in the C API manual. Off the top of my head I don't know what it is ...

(I don't have an immediate answer. I shall give it some thought.) Meanwhile, if you post on Developer Net you may get an earlier response.

It may have something to do with XP SP2 - check with your support provider as to whether there are any known issues on this platform.

Yes/no/maybe. The problem in Oracle is that the DBA usually wants to exert some control over what tablespaces (etc.) get used. It would be really tricky to implement this generically.

Why do I say it's not much of a gain? Because 1000MB is only 1MB more than 999MB. The limit in the client is an artifact of the spin button control only supporting three digits. The limit in uvconfig is a documented maximum. I have never tried setting it higher.

You can change an individual Sequential File stage pad character on the Format tab. You can change it individually within the Columns grid, either by scrolling to the right or by choosing Edit Row from the right mouse menu. But, I feel, your question is where does the default for all Sequential File...

Insert only will generate a new value of TID for every row sent - that is, because the INSERT statement is tried first under an "insert or update" rule, the auto-incrementing key will mean that the insert will succeed for every row. You would be better off to have two streams from the Transformer to...

Whenever you start DataStage you should verify that the DataStage RPC daemon (or service, if on Windows) was started. On UNIX this runs as dsrpcd, so a suitable command to determine whether it is running would be ps -ef | grep dsprcd | grep -v grep On Windows-based servers you can simply examine the...

Please don't hijack threads. Neither of your questions relates to trimming leading zeroes from strings in parallel jobs. Please start a separate thread for each, to assist future searchers.

Currently I'm working on a 7.0 site - no Advanced manual.

My guess is that you're trying to write to a hashed file, but there's something awry with the key value (where's the trailing quote character in the error message?). What happens if your target is a sequential file?

What is your target? For example if you're loading a hashed file, duplicate key values are destructively overwritten. Do you have a constraint on your output link in the job design? Without knowing these kinds of things, it's really difficult to diagnose your "problem".