DSXchange

Yes, but you run out of resources fairly fast. Processing nodes are logical, unrelated to the number of CPUs. However one controlling process plus up to one player process per stage is generated for each processing node. So there can be a lot of processes competing for that one CPU.

How about seven different jobs, each appending to the CSV file? These could be run from a job sequence which creates/truncates the CSV file via an Execute Command activity.

Involve business analysts. The first step, irrespective of the tool ultimately chosen, is to plan the migration. Deliverable from this phase is a set of target-from-source mapping documents. Combined with entity-relationship diagrams of the target database you can then plan the load order. Other fac...

You can get the GMT time from the System() function, so presumably can get the offset via arithmetic. And, of course, you can get the time zone from the TZ environment variable.

In what format do you require this "timestamp"?

There are some folks on the forum with DataStage MVS knowledge. When you're searching the forum, it helps to know that it used to be known as DataStage 390; including "390" in searches will find those entries that lack the "MVS" string.

Get on a 28.8 kbps dial-up line, e.g. from a hotel or airport lounge. You don't notice additional slowness.

A parallel routine would need to be written in C++, and you would need to figure out some way to mimic a key-based write to some kind of structure (hashed files not being directly available). But, theoretically, it's do-able. You might consider investigating the Surrogate Key Generator stage in para...

Open status view in Director, select your category. Use Filter to restrict by status if required. Choose Print from the Project menu. If needed, check the Print to File check box. Select options to suit your requirements.

Switch is only on the value of the selector.
Filter is based on an expression (a WHERE-like expression, though LIKE requires regular expressions).

Is Scale 0 or is Scale empty? (If the latter there's a problem with the import process - try importing Orchestrate schema definition using dbutil to access the table.) The two values you've cited are, of course, the minimum and maximum possible int32 values; DataStage treats Decimal without a scale ...

Unless your stage is operating in sequential mode (which rather defeats the purpose of having parallel jobs), you are generating multiple streams of values. If you need a strategy for generating unique numbers across all streams, try a cycle beginning with the partition number and incrementing by th...

Private Message Hi, Can u pls let me know as to how to convert the time to GMT or other time zones from the given timestamp. Thanks, kalyan Response I can, but an approach via private message or private email is regarded as a request to engage professional services. If that's what you'd like - for ...

Welcome aboard. :D

The answer is no.

Unless you use the BASIC Transformer stage in a parallel job (which has some performance overheads), in which you can use the Oconv() function.

There are no plug-in stages for parallel jobs. Your search is ended. You can, of course, create your own stages - there are three different kinds of these; Wrapper, Build and Custom. Read about these in the Advanced Parallel Job Developer's Guide which is in the Docs folder on your client machine.

Start with "The Elements of Programming Style" so that you can learn about designing functions. Then a good primer on the C++ programming language. Design, code, compile and test your C++ function (adapt an existing or create a new make file). Build it into a shared library, if you haven't already d...