DSXchange

Of course, provided you don't break any of the rules (Chapter 2 of the Parallel Job Developers Guide manual).

There's a command line interface called oerr that can do it for you. From memory the syntax would be I expect you could use an External Filter stage to execute something like oerr ORA $1

I don't see any mention of compiling and linking your C++ routine, nor any evidence that it compiled successfully and lacked a main() function.

Block move is not possible without hacking either the DS_JOBOBJECTS record or the DSX file.

Imagine a scenario in which the default configuration file has four nodes and three resource disk directories in each. And, for the sake of the argument, that they are twelve separate directories. When the job is run on a grid, and a dynamic configuration file is generated, how are the resource disk...

Don't know. Not a Sybase expert.

Would think so, based on how the Oracle Enterprise stage works.

Did you not know that you can rearrange the order of any grid in DataStage? Select the "key" column - usually the leftmost - and slide it up or down, usually using the right mouse button for the drag/drop but just occasionally the left (ya gotta love the consistency). There is another way,...

Some. The rest of the answer is tied up in the "how long is a piece of string" nature of any "impact on performance" question - what's the job doing, what else is happening, how busy is the metadata delivery service, how busy is the network if XMETA is on a different machine, and...

1) If you find fifty stage variables and one that concatenates them all into a string, then you'll find one that does the same plus inserts dynamic array delimiters even more difficult to maintain. And then there's maintaining the routine itself. The parsing into fifty fields and directing each to t...

Keep in mind also that server jobs in version 8 operate in a "cocoon" in the parallel execution environment. Anything that has to use the services, such as metadata checking, has to go via translation into and back from strongly typed. This will necessarily introduce some overhead, though ...

It's not available.

You use Sybase Enterprise stage, with write mode set to ASE Write or IQ Write. (Write is used to write and export data into a single table.)

Try using a Complex Flat File stage, which has got this functionality built right in.

Well, there's always the static hashed file approach, but I agree with Ken's assessment. Maintaining static hashed files is more trouble than it's worth (this includes getting the initial size right).

This just in.

XMETA is generally based on the "hub" used by the old MetaStage product - it has to have the flexibility to accept, store and deliver metadata in all different kinds of format, as well as to provide effective governance over those metadata (being a service-oriented architecture helps with ...