DSXchange

Sorry, I'm not familiar enough with the date/time functions in PX to give anything other than high-level advice. So, you don't need to figure out the time difference, just if the timezone change affected the date or not? Make sure your requirement is clear, then others can give you specific help wit...

That is the full error that you get? Never heard of that one and I couldn't get Google couldn't turn up anything for it either. Have you asked your DBA what that error means?

Assuming you have the parameters you've shown? Adjust the time by the difference in them: -2.5 hours in your example.

Which will kill your performance but prove (if it then works) that your design is correct. As you suggested I just sent both Insert link and Delete link into single DRDBMS stage and also ensured link ordering was proper from Transformer stage so that Delete operation works first and then followed by...

You need to make the values match if we're talking hashed lookup. So either remove the leading zeroes in the lookup or zero pad the driving records to match. If the lookup is a database stage, then it shouldn't matter and an implicit conversion would make the value match automagically. Like in Toad.

There's no manual that will say "don't add one of these to every job". The Inter-Process Stages are documented in the Server Job Developer's Guide in Chapter 12, but all that's going to tell you how much of a wonderful job it will do speeding all your jobs up. The only way you'll get "concrete proof...

That's the DataStage RPC Daemon, allowing client connections to the repository. Not sure what it would have to do with a 'compile failing'.

But still no luck as job used to try to insert data first and then try to delete. Which resulted in Database constraint violation. Used to try? You need to do a more thorough job of detailing your requirements. Describe your complete job flow. What exactly are you trying to delete? What exactly are...

Seems like you need to replace all occurances of ExecDOS with ExecSH and convert the DOS commands to UNIX ones as well.

Windows only stage. I think Ernie Ostic explained the history behind the stage, a search should turn his post up.

You can only use one client at a time and can't have any client tools open when you 'switch'.

One thing to keep in mind - I don't believe that the 'environment variables' concept was fully baked in the 7.0 release...

As long as they are installed into separate directories and you also install the MCM as noted, you'll be fine.

I deal with Oracle every day and this is just... wrong. Sorry.

You simply copy it to the clipboard from the log and place it anywhere you like. Then edit to your heart's content with your favorite editing tool. When done, I've already said where it goes back in the job. If you are like me and XSLT illiterate enlist the help of someone who isn't. Explain the si...