DSXchange

I wouldn't have suggested it if you couldn't do it.

It may not be obvious, but you can take a single job and 'Add to Schedule' as many times as makes sense.

Actually, every job 'uses' hashed files - they are used to store all of the information about the job itself, design, config, etc etc. And that is what seems to be corrupted in your case, the job. Can you export the job design (just that) successfully? If so, I'd suggest you do so, then reimport the...

Welcome. :D

Upload screenshots to any of the file sharing websites out there and then use the [Img] 'Image' tags to include links to them here. Most if not all sites will generate the tags for you automatically.

I don't believe so, but if it does I'm sure you'll let us know.

If you have that problem, try switching it to use DSExecute() and call 'sendmail' directly, that should work fine.

10g is one release newer than 9i. Your DBA should be able to tell you what's new in 10g, that or Google.

What does this have to do with "datastage designer"? (original subject)

You better reorder those stage variables if you want them to work. And you only really need one, if any at all, not three.

What about leap years? That complicates things but would need to be considered if you want this to be bullet proof.

Figured that would come next. You need to either 'cd' to the directory where the command lives then execute it, or include that directory in your PATH statement or fully path the command.

"Command line" means operating system command line, which is not where you are. Open a DOS / Command Prompt window and try it from there.

No need to take that same scripted approach that the stage does. Look into the Routine Activity idea that I posted. Replace the Notification Activity stage with a Routine Activity stage that does the emailing. Should be simple enough to setup and won't have the multi-instance problem that you are se...

Does not IConv and OConv work in PX? You'd also need to define what '4 years' means to you, are you literally wanting to decrement the year portion of the date by four, subtract (4*365) days, something else?

I would still report it as a bug if you haven't done so already. Any way to consolidate the notifications? Have one master sequence that handles all other invocations and the emails, perhaps? You could also write your own email routine, invoke 'sendmail' or whatever you like with DSExecute(), it sho...

That sounds like a bug that should be reported to your official support provider. Each Notification Activity creates a shell script that it executes and then deletes. Sounds like all of the instances are using the same filename and depending on the timing, another instance deletes the script that so...

rsiem wrote:These drivers seem to be for a later version of Data Direct than the one that ships with Datastage though.

What makes you say that?

To convert the implied decimal, you'll need to divide the field by 100 during the conversion.

singhald wrote:but if you know please tell us, how datastage able to do export job by selecting single category.

Because that capability is built into the GUI. Doesn't mean there has to be a command line equivalent... and there isn't.