DSXchange

Of course! You need to locate and install the Multi Client Manager - or MCM - it should be on the 7.5.1A cdrom. That will allow you to switch between the two clients as only one can be active at any given time.

And as you've found, without it only the last version installed works.

Ernie - this is a continuation of a previous post where usage of this stage in a PX job generates a 'unable to load' error when the job runs. Hence the (possibly) erroneous advice that perhaps some of these system variables are not properly set. I've used them in Server jobs after installing the PAC...

What happens when it's 10 PM? Let's say the time is 10:18:19 PM - what happens when you take the right 10 characters? Same with the dates - months and days can be a single digit or two digits in your format. Better to use the field command to split it, not a fixed substring. Tell it that the field i...

Your time transformation isn't quite right. You need to tell it that it is coming in in 12 hour format but you want it out in 24 hour format. Try this:

How did you check the result? Just because you loaded it with a time doesn't mean you have to select the time when you select the date. If you are not sure your transforms are correct, write them to a flat file along with the source field so you can check the results outside of Oracle. You can remov...

Why would you want to reinvent the wheel and not do this in a Sequence? Yes, you can do this 'after job', not in a transformer. Build a routine that captures the interim status of the job (remember, even after job it is still running so hasn't quite finished yet) and then email out whatever you feel...

Craig, I use to see some of your other posts as well where you insist not using User defined SQL. Will there be any performance improvement in using Bult in SQL or just for the sake of avoiding some generic errors? No, it's not about performance - it's about standards and maintenance. My stance on ...

You need to split your value into its component pieces - date and time. Use IConv to convert both to internal format and then OConv to get them back in the format Oracle expects: YYYY-MM-DD HH24:MI:SS Both pieces are converted separately and then concatenated back together with a space between them....

Yah, go ahead - I dares ya.

The CDROM has a readme file on it. Installing the client puts a pdf document in the usual place called WSPACK_Designer.pdf. Neither of which mention any special configuration requirements for the product, btw. Your problem may be the fact that you are using the stages in a PX job. From the Designer ...

'Finishing'? There's no such status that I recall. Where do you see this - specific message inside the job log? Can you post an example or two of these messages if that's the case?

Also, does this job have any 'After Job' activities it is performing?

Your mixture of key fields makes a single job solution... messy at best. I'm sure one could come up with a way (I've done things like this in the past) but you're much better off with a two job solution. IMHO.

Yes - for 'DNS' you need to supply a proper name from your tnsnames.ora file, just like you would for TOAD or any other tool. You must be using User-Defined SQL to have the 'table name' be missing. Since you're not letting the stage generate the sql (and why not?) then put anything in the TABLE prop...

Your dates would need to be in YYYY-MM-DD format to sort correctly. Probably easiest to leave them as strings in that format thru the sort.

Build two jobs - one to get unique values of Key1 from the data and issue the deletes and the second job can then load the data.