DSXchange

The first question is whether the escaped pipe character is part of the string making up field #2, or whether they need to be treated as delimiters (which you seem to be assuming). The quotes around field #2 suggest that the former situation actually obtains, as Craig noted.

While Version Control no longer exists, Information Server Manager allows one to interact with source code control systems. You might like to investigate that mechanism. (An Eclipse plug-in is required for non-IBM source code control systems.)

What Craig said.

You should be able to call the same webservice over and over, provided that one call is finished before the next is made.

No, projects can be located anywhere except the root directory.

Have you compared the files? I don't really have time at the moment.

Status 2 is "finished with warnings". So it looks like dsjob is starting the job satisfactorily in production. What's different in the other environment?

This is most easily achieved when importing the table definition for the Sequential File.

Is this DataStage AS a web service, or DataStage CALLING a web service?

Make the output columns nullable for the Pivot stage (it generates NULL for non-existing input), and deal with the nullability downstream.

... and, before that:
export APT_ORCHHOME=$DSHOME/../PXEngine

Are you running the 8.1 dsjob command?

When one opens the Display option in the Data Browser and only wants to look at a few column, one must manually unselect every other column individually. Would like to see some kind of "Unselect All" control being available.

Have you performed the echo commands, particularly for $DS_PORT, in production?

Find out what the values of these are. Why are there two references in $DS_PORT ? This will lead to an invalid command line.

How do you know that the answer is 9? They don't reveal the correct answer.

If you're depending upon so-called certification exam preparation websites, don't waste your time. Errors are pervasive on these websites.