DSXchange

No.

The DataStage job - or metadata importer - is the client, the ODBC driver is the protocol, and the database server is the server.

Therefore the ODBC driver (and driver manager) must be on the same machine as the DataStage server.

Technical Note
This is an artifact of DataStage BASIC behaviour that will present any arithmetic result as the shortest possible string. It is for this reason that adding zero to a number is the easiest (= most efficient) mechanism for removing leading and trailing non-significant zeroes.

Doesn't need to be sequential. But it does need to be partitioned correctly - that is, on the grouping columns.

They are actually totally different products.

You can intend whatever you please, but you will not be able to implement anything that is impossible.

Beware that the BASIC Transformer stage is not supported for MPP environments.

You can install versions 3.0 and 7.5 side by side on the same server, but you must make sure they are installed in different directories. Version 3.0 uses UniVerse as its underlying engine, records the location of the engine directory in /.uvhome, uses uvrpcd listening on port #31438 and uses 0xace ...

Please double check that you have selected a Sequential File stage. It is very unusual to get an FTP message from this stage. Further, unless there is a link connected to the stage, then there is no "browse for file" capability (the file name is a property of the link, not of the stage). So please s...

Yes, that is an easy solution. Within the loop perform any innocuous task that requires connection to DB2 - even a command the connects then quits. When the exit status is zero, it's time to progress to Job1. Don't forget to include a small sleep in the loop so that you don't eat too much CPU.

Do you actually have DataStage TX licensed?

Thanks for posting the resolution. Did the DataStage job log contain an error message that indicated insufficient permission?

No idea. The reason we have no idea is that you have posted no detail of your job (and job sequence?) design, for example what stage types are being used, nor any detail of the routine you are invoking. Right now your question is in the category of "my car won't start, what's wrong with it?". More d...

Probably a script, executed via an Execute Command activity, that establishes an FTP connection then tests for the existence of the file. Does FTP into the mainframe support the ls subcommand for ftp?

There are no magic bullets. There are two problems in this thread, and no indication given anywhere that an environment variable will fix either of them. Why do you believe (hope?) that there is? The pathname "\\." indicates "current machine". The pathname "\\.\pipe" therefore suggests a (sub)direct...

Search also for DS.REINDEX

In particular there appears to be a problem resolving the address of the remote system to the host name specified. Is your name resolution service not working? As a test, try specifying the remote machine's IP address instead of its name.

As a general rule, there will be no impact. The only major exception is if your designs involve a lot of repartitioning, which means that rows have to move between player processes on different processing nodes. In an SMP environment this is managed through shared memory; in an MPP environment the m...