DSXchange

DATE fields in Oracle are timestamps. I use them with a datatype of Timestamp without issue and actually prefer to always include the time portion of the DATE field even when it "doesn't have one".

Did you actually try it? What issues did you have?

Who knows? Does this just happen to you or everyone? If just you then try uninstalling and then reinstalling the client software on your pc.

Of course you can attach to an aborted job, and the code you posted does just that and nothing more. You'd need to take an extra step to reset an aborted job before attempting to run it and it sounds like you're not doing that. As noted in other replies to you, you can use the DSPrepareJob function ...

This is going nowhere. Start over. State the problem you are trying to solve. Include an example of your input data and what you think your output needs to be.

The job must abort for any rollback to happen. You need to make sure this happens by setting a very low warning threshold, a reject link set to abort after 1 record, using the 'treat warning as fatal' option in the OCI stage, etc etc.

If your problem is solved, then please mark the post as Resolved using the big button at the top of the screen.

This can turn into a large conversation, but you need to precreate the hashed file with an appropriate size for the volume by setting the Minimum Modulos to something other than the default of 1.

No, the routine would replace the use of the Notification Activity stage.

JobA would need to be a multiple instance job or yes - an attempt to run it while it is currently running will fail.

Don't wait "15 minutes", wait for the ports that are in use to clear. You can use 'netstat -a' and grep for 'dsrpc'. Once that returns zero results then DataStage can be restarted.

Time to mark the topic as Resolved then, using the green button at the top of the screen.

kishorebhulokam wrote:I am using Datastage 7.0, I want to send a log file when the job gets fail.how to Attach a Log File in Email-Notification activity.is there any property to set this ..

No, not until you upgrade to at least the 7.5 version. Stick with your routine for now.

From the linked thread:

wengkin76 wrote:Got it working by applying fixpak1a.

That's all the details you'd need, at least for right now. Request the DataStage 'fixpak' from your official support provider, see if that solves your problem.

sorry i don't how to start dsrpcd debug mode can you help me Search the forums. With nothing but Exact Match really working you'll need to search for something like "RPC Daemon is not running" to find the various conversations on how to start it in debug mode to determine exactly what's happening. ...

Scope wrote:I have found dsrpc is not in /etc/services.

this is a problem?

No, it lives in $DSHOME/bin.

Edited to add: D'oh, that's what I get for answering just after waking up. Yes, it needs to be listed there.