DSXchange

Ziggacclly.

Reset and run immediately after a job failure is not adviced. It will lead to more problem than answers.

You need to check whether the case of alphabetic chars matter. If it does, you need to change the command a little.

But then, these error messages are there for a purpose. The message clearly says that you are attempting to alter a record value and you are not successful in performing that. So you need to have a design that caters for this failure to be traced and recorded....not hidden and forgotten.

Try the following

This appears to be an enhancement of Director to display details in all the projects....something like the host view in Manager. Simplest will be to have multiple director sessions open - one for each project. Otherwise you can extract the info you want and simulate the view using other software suc...

You need to apply functions / transformations such as handle_null.

SQL Loader works better and can be tuned efficiently using manual methods than the one given by DataStage.

You need to try different values for 'number of rows' to get the correct balance.

If you attempt to insert, you need to define ALL the primary keys as you cannot have any duplicates of them.

Similarly, an update without all primary keys may result in updating multiple rows.

They will be rejected, if you have a reject stream.

As mentioned before, all it ways is that it was not able to locate the row with the key in the table.

Use reference lookup to reject them.

Alternatively, if your design is to be altered to 'insert or update rows', then look into it.

The above is not a winking symbol. It was supposed to mean a semi-colon within brakets.

You can use semi-colon (;) or any other char as your delimiter and then convert them into tabular fashion within Excel.

It is normally viceversa. You create users who are then included in the dstage group.

You can use parameters and make it a shared container.