DSXchange

Oh come on! Look at all the layers between DataStage (on UNIX) and SQL Server (on Windows). You shouldn't be at all surprised. Manage expectations better.

DataStage is just another client application as far as Oracle is concerned. As with any other client, you need to provide sufficient qualification to ensure that the Oracle object in question is accessible. Thus, for example, if the Oracle user connects to a different schema by default, you need to ...

Insert a Copy stage as the message indicates. This is a known issue and you have been given the workaround.

Start by specifying (on paper) what your validation rules are.

If these columns are coming from a database, generate the SELECT statement dynamically by reading a sample of column names for that table from the system table (the name of which will be something like SYSCOLUMNS or ALL_COLUMNS).

Shared Container sounds like a good idea to me. Emplace it in the link that sends insert rows to the target.

What happens if you mark start_date and end_date as Key in the job's metadata?

The Sequential File stage uses the STREAMS I/O module under the covers. It therefore has no size limit to the volume of data it can handle.

Thank you for sharing that.

You might also consider using values files of Parameter Sets.

You will have to wait until the next time that U logs in (U is one of our members) or, perhaps, learn that the second person personal pronoun in English is spelled "you". The design mechanism has to record, or determine on restart, how many records actually (successfully) made it into the ...

All access to the common metadata repository is via services; Connector Access Service is simply the name of the service used by Connectors to work with the repository.

Search a DB2 forum or Google. What do these particular DB2 error codes mean?

I think you'd better describe precisely how you went about trying to change the icon image. If that's the only change, then clearly that's the cause of your problem.

Maybe you need to back away from the expectation that everything can be done generically with no columns defined.

As a general rule, if you expect DataStage to transform anything, you have to tell it what that thing is, and how it is to effect the transformation.

Why not use a Nested Condition within the loop to verify that the $Counter activity variable is not empty?