DSXchange

Is this a server job or a mainframe job? You can not start mainframe jobs with the dsjob utility.

Parallel jobs are not equipped to do this kind of real-time updating without running in sequential mode and using auto-commit, both of which slow things down. It is regarded as a "blocking" activity. Also, you will not be able to get it to work with virtual Data Sets, so you're pretty much constrain...

Define it! Use the User-Defined area of environment variables in Administrator. A suitable default value is "." (the current directory).

The term is not one of which I am aware. Are you totally certain about the terminology?

You need to purchase it.

Have you executed bind20 as part of setting up DB2 connectivity?

20 is hexadecimal for 32, which is the space character. I don't see pipe characters in those records, but agree that there are some in the final record that you have just posted.

See if you can find any lines in the file(s) where there is no pipe character, for example grep -v '|' filename

Have these developers simply stayed logged in?

You don't do assignment in expressions. The original expression should be

There is a separate document on configuring connectivity to DB2, particularly when the DB2 instance is not on the same machine as DataStage server. In your case, DB2 Connect will need to be installed on the DataStage server machine so that you can access data in the AS/400 environment, and you must ...

To put that another way, DataStage must be able to construct the full schema from somewhere - whether internal metadata or an external schema file.

I don't currently have access to PX but would imagine that discard file is an optional property of the load stage. If you can find it (in Available Properties to Add), you can use a job parameter to supply its value.

From the log, how many rows were sent to the target? Insert a Peek stage between them to determine whether the 10 rows made it into the job.

libgciudt6.so is a shared library for accessing UniData 6.0 databases. It is (deliberately or accidentally) not included with all versions of DataStage. Alas, it is hard coded into the uv executable to open it, even though you don't access UniData databases. Contact your support provider to obtain ...

When Column definitions are loaded into a DataStage job, or saved into the Repository from a DataStage job, the location of the table definition in the Repository is preserved within the job. To see these, right click on the Columns grid and choose Properties - you can then expose the additional fie...