DSXchange

And how you are "running" it. Otherwise there's absolutely no way for anyone to help you.

I would think you need to use the proper domain in the command line rather than 'none'.

First suggestion will always be to search the forums here, the topic of how to do a "vertical pivot" has been discussed here quite a bit.

I'm not sure how to differentiate those two just by checking the status code, you might ping your official support provider and see what they say. Worst case, I think you should be able to take an aborted Sequence and use "dsjob -jobinfo" to get the full text version of its status, then gr...

What is your source characterset? "ROSS" may be only four characters but your target only supports 10 bytes and "ROSS" seems to be 12 bytes.

I've built something similar using a single output exception record with dedicated fields for each possible field exception. Last step before loading them to the target table is a horizontal pivot of columns to rows with a filter to remove any 'empty' records.

The 1980 part is unneeded with a 4 digit year as is "mmm" with a 2 digit month. Are both of your examples strings? Or is one an actual Date? That changes the answer, but the StringToDate() and DateToString() functions are what you need to become familiar with.

How are you partitioning your data? Hash partitioned over the key fields?

You can't. That's one of the "problems" with using a combo action like that. Take a copy of the table and compare them after the next run. Better yet, change your job to perform separate actions - insert or update - as needed. If this is something you really need to track, the table should...

You need to check with your SysAdmin to ensure that any scheduling user is in "cron.allow", meaning you are authorized to use cron.

le thuong wrote:Small transformations have to be done on the data.

This part, if true, would seem to preclude the use of RCP.

First step? Kind of crazy, I know, but you really should read the included Installation and Configuration Guide pdf.

And now here you are in your own topic...

Interesting... I could swear I'd read here that the MCM didn't work with multiple versions of the 8.x client. We all know it works with multiple 7.x versions or 7.x versions with a single 8.x version (which I've used) but I thought multiple 8s... ah, I must be thinking of multiple server installs he...

I believe the client is still just 32bit. I also believe that multiple 8.x clients are not support, meaning only one can be installed at any given time. I'm sure someone will be along to confirm or deny...