DSXchange

Yes, look at your Transform stage and the setting for "Abort after rows"

Hmmm, that is not much to go on. I would check the constraint again, as that seems to not be working as you expect.

The statement starts with "SELECT", so wouldn't that be your source DB2 stage? Do you use custom SQL in the stage and what is the SELECT statement?

splayer, could you explain the constraint please?

Although they always say "turn off anti-virus software before installing" I've never had to do that, but perhaps in your case that might be causing an issue. DS install on XP Pro has worked for me. Before you re-try, make sure to clean out directories and also remove any registry entries for DataSta...

Is "CODE1" as Stage variable? Is so, how is it derived?

What errors have you seen during installation?

Pierre, I thought that the AT command would accept English mnemonics. Can you manually try to add something like "/EVERY:M dir"? I checked on a German Windows and "/EVERY" is legal, but perhaps the days are not accepted in English (service isn't started so I couldn't check in detail). It sounds like...

Good catch, Craig; I missed that. While some have had success on XP Pro, it is not a supported platform. I know of nobody who has had success running the server on XP Home.

You need to derive this using the "NextSurrogateKey" function.

Please refrain from using "urgent" in posts - all are treated equally in the forum with the exception of "immediate" and "urgent", those usually end up waiting longer. Has this worked before from the same workstation? Are you appending ":9080" to the host? Has someone on the system changed the firew...

That could happen if someone unsuccessfully tried to compile the routine.

Normally these services do not need to be stopped in order to install DataStage.

What services do you mean?

In the user-variable stage, use the drop-down select list in the derivation to get the return value from your UNIX command stage.