DSXchange

Since your DataStage server is on Windows, why not just read the .xls file directly via ODBC?

You can't just simply stop and immediately restart it, you need to check between those two steps and wait for it to come 'all the way down' and release all ports in use. Failure to do so can mean the engine comes up but the dsrpcd deamon cannot start and therefor you cannot connect to any of the pro...

You'd have to provide details of the job for anyone to help. I've seen issues like this selecting CLOB data from Oracle when the array size is greater than one, doing anything like that?

Then why not simply put a delete statement for those values (same as you would run in Toad or sqlplus) anywhere that runs before the main stage actions. For OCI, 'before sql'. For the Enterprise stage, in the 'Open' statement area I would guess.

If you want to continue to use the Notification Activity stage, then the only way to not have that warning is to ensure both files exist. That or use multiple stages, one for each combination of existence. That our write your own email routine that knows that one or both attachments may not exist an...

No.

You create a new post and reference anything related you think may help by posting links to them, much like I did.

Check the one that "doesn't work" - you changed what I posted. Angle brackets, not square brackets.

No, I don't think you're reading it wrong. It's obvious their assertion that they were able to create an appropriate .dsx file is incorrect. Compare your file to a 'real' file - what's missing / wrong?

Oh, and here too:

http://www.dsxchange.com/viewtopic.php?t=122696

How many times are you going to post this question?

What O/S? Where - local to the DataStage server? Remote? Details of your requirements would be nice.

Looks like you've already asked this question in someone else's thread and Ernie has helped you there.

http://www.dsxchange.com/viewtopic.php?p=302900#302900

Details? How about posting an example of what you are trying to generate and explaining your job design?

Output from the Execute Command stage is returned in a dynamic array, which means there's more to that zero than meets the eye. It's actually a zero followed by a Field Mark, which is why your test fails. Couple of solutions. Either check just the first element of the array or remove the field mark....

Yes, you are confusing us. You always need to delete records where those three columns have those three values regardless of the input data? Or you need to delete those values because they are in the input data? The former calls for hard-coding and the latter calls for getting your delete syntax cor...

You're missing the point. You don't "enable" it, there's nothing to enable. For bulk loading you have basically two choices: 1. You use one of the Bulk Loader stages. For example, for Oracle you could use the 'Oracle OCI Load' a.k.a. the ORAOCIBL stage in 'automatic' mode. 2. You do it the old fashi...