DSXchange

You need read, write and execute permission to DS_STAGETYPES and read and write permission to the three files within it (DATA.30, OVER.30 and .Type30). Actually you don't need write permission to the .Type30 file.

You could have searched the forum rather than waiting for me to awake from my beauty sleep.

Bring environment variable APT_DISABLE_COMBINATION into your job as a job parameter and set it to True.

Every stage can also have its combinability set on the Advanced tab.

Does this happen all the time or only sometimes? If only sometimes, is it when the system is busy? This was actually the more important sentence in my previous post. The timeout that occurs may or may not be at the boundary between the parallel, stongly-typed environment and the server, un-typed en...

There is no "server only" certification, and none likely in the short term. IBM have avoided ruling it out completely, but it's not on the plan for exams being developed in the next 12 months. (I learned this by asking the person in charge of certifications at the Information on Demand conference. T...

Yes, given that you have version 8.x, and provided also that you have the .NET C++ compiler for any job that includes a Transformer or Build stage.

There is a Transaction Control tab on the ODBC stage if it has more than one input link. Examine that as a good example. The statement about control was derived by examination of stage trace. You enable stage tracing when running a job from Director. Collecting the actual subroutine calls in the tra...

You use DataStage, not DB2, for the DataStage Repository, since your DataStage version is 7.

The name of the table is RT_LOGnnn, where nnn is the job number. Each job has its own, separate, log table.

A simpler solution would be to get the date/time within a generating expression in the user variables activity.

Does this happen all the time or only sometimes? If only sometimes, is it when the system is busy? Are you executing this job on a single machine (SMP environment) or multiple machines (MPP or grid environment)?

We do not even attempt to solve problems reported by this operator.

Disable operator combination so that you can discern which stage (operator) is actually generating the error.

Yes you do. Use Upsert mode (user-defined SQL) and make sure in your job design that existing key values never get sent into the Oracle Enterprise stage.

Write out an algorithm (specification) in English. You will then easily be able to see precisely what you need to do in your job sequence (note: a sequencer is a component in a job sequence) and easily implement it. You should not need to create a shell script (unless you want to); the flexibility o...

It's in the DataStage Repository database. You can execute queries from the Administrator client Command window, or after establishing a telnet session and opening dssh in the project on the server.

Go to the IOD 2008 conference in the last week of October in Las Vegas and you can take the tests for free (up to three attempts, anyway, any more are at a discounted rate).

Does the stored procedure name exist in the database instance to which you are connecting? Are you (the user ID used to run the job) its owner? In either case, you may need to provide a stored procedure name qualified by a schema/owner name.