DSXchange

And then explain exactly what "doesn't work" means.

Sounds like the SP2 bug I mentioned... is that possible?

Thanks guys... I think Mat should be good to go now.

I prefer to archive files of this type rather than simply removing them. This could be accomplished using the 'mv' command rather than 'rm', but you'd typically want to take an extra step to 'timestamp' the file as well in a script. We also use tar and compress to periodically create 'tar balls' of...

Interesting. That's certainly not the behaviour I'm seeing. Perhaps it is version related? I am running the 7.x version of DataStage and the export command rather than the 6.x version that you are. Other than that... Maybe you could try Kim's version which 'unlocks' all of the jobs first. Sounds lik...

If I try to access its properties nothing is display and when I write click on it the "open job" function is greyed out. The 'warning triangles' are normal and just mean you haven't 'configured' or added any metadata to the stage yet. I don't understand what 'nothing is displayed' means when you ac...

It's not working fine... it can't be. Sequential files are by definition single writer type structures and cannot be (successfully) written to simultaneously by multiple processes. This is not a DataStage 'limitation' but the nature of the beast. You either need to append to the file in a serial fas...

As my OS is Windows and UNIX so can any one put some light on this issue. You might want to clarify this. It's one or the other when discussing server platforms. Issue the 'blat' command from the command line yourself, passing it 9 email addresses and a file attachment to send. If it works like tha...

THAT I would have believed.

Not sure if you have a question here or not... but I'd suggest sticking with the syntax that works.

Silly question, but if it's not there, are you sure you are running PX? I thought it was still in 'beta' for Windows. The other confusion is PX for Windows only runs on what - Windows Server 2003? - XP is not a supported platform for any product other than the client, as far as I know.

You might also want to explain what "truncate is not working" means. If it's a permissions problem, I'd be surprised if you could turn around and drop the table. Plus, don't forget you'd lose everything associated with that table when you drop it - grants, indexes, yada yada yada. Those (if any) wou...

Some sort of 'auto-compile' might help too, I would think, as that removes them as well.

Not something that I believe we can answer. First off, since you are on a Windows server, what are you using for email? Something like 'blat' or ??. Let us know and then others might be able to give you more specific help. That would be where I would start looking for answers right now as I really d...

Ok, just because this is bugging me and I really want to understand this Wurlod Nugget o' Fun... how does it return a '2'? I can see how it returns the '0' on the other side the 'else' but it actually sets a variable called COUNTRY_CDE to '2', not 'Ans' when the expression is true - hence the puzzle...