DSXchange

Create the environment variables in the Adminitrator client. Add them as job parameters to your jobs. In the jobs set the job parameter default value to the special token $PROJDEF. Compile. When you run the job, it will pick up the values from those specified in the Administrator client. Deploy your...

One from localhost, one from the real dsrpcd. Don't know why. Does it affect client connectivity?

Any time you see "internal error" involve your support provider. Even if the debugger were available in your PATH, its output is highly unlikely to be meaningful to you.

Status 0 can also mean that the job is already running. which also explains why an approach involving polling was required.

If the data streams are independent, you might investigate the use of multi-instance running.

Your stage lacks a table name or user-define QL query.

When you do your View Data, click the View OSH button, and post the OSH here. This will confirm my diagnosis.

Without the EXACT error messages we are unable to assist further.

The fact that restarting the services clears the problem is interesting, but is not enough in itself to help to solve whatever the problem is.

Help us to help you.

It is not good practice to have to restart production servers!

The control file name for both File Sets and Lookup File Sets must end in ".fs".

Is this another interview question? As far as I am aware there is no capability built in to job sequences to use a "process control table", whatever that may be. Once you've figured out what it is, then maybe you could incorporate its use via your own design, but there's nothing "out of the box".

Look at the /etc/services file for the system that is working. Is there an entry there for uvrpc or uvrpcd? If so, mimic it in the /etc/services file of the system where it is not working. Otherwise duplicate the dsrpc (or dsrpcd) entry in the /etc/services file in the new system, substituting "uv" ...

Etiquette Note We don't do "urgent" here. if you require urgent support sign up with your support provider for premium service and learn the true cost of "urgent". DSXchange is an all-volunteer site on which participants post as and when they can. No. The operating system allows only one writer pro...

Curiously this works the other way around to what you might expect from the other conversions. Oconv(42,"MP") returns the characters of 42 (that is, "4" and "2") represented as byte values in hexadecimal, namely "34" and "32" (the ASCII code for "4" is 52 and the ASCII code for "2" is 50). Iconv(343...

The exit status of dsjob is (can be) affected by its arguments. For example the -jobstatus argument causes the job's status (0 = running, 1 = finished, etc.) to be the exit status of the dsjob command. Read about these variations in either the Server Job Developer's Guide or the Parallel Job Develop...

Make sure, too, that the MQ Series server is on the same machine as the DataStage server.

This requirement is removed in version 8.0, when it is sufficient to have an MQ Series client on the DataStage server machine.

Arnd already has. You will not get the accurate row count until all rows have been processed. Ask your question in an after-stage or after-job subroutine.