DSXchange

Details would be good. For example - how, exactly, are you doing the decryption "through DataStage application"? We may need to see your syntax as well. Whatever you think might help. Out of curiousity, when it works fine from the command prompt, does it prompt you for anything or does it ...

Nope.

Ask a DBA to kill it.

Yes. A job is a job.

Let's start with specifics of your Sequence job's design and the triggers involved. Also must note that others have posted the same issue in the past and (from what I recall) the solution isn't as straight-forward as it might seem it should be. Let me see if I can turn up any of those posts...

First, draw us a picture of your Sequence job either with words or "ascii art" that lets us know the design. Make sure all of the trigger information is posted as well.

I've posted about this before and still feel like it's worth posting. One approach would be to use a 3rd party tool to farm all of the current hashed files being used (as in read from or written to) from a dsx export of the project. Chuck Smith has such a beastie here and it is easily modifiable to ...

Same issue as posted here by any chance?

Yah, you need to let us know if your record is legitimately larger than 100,000 bytes or not. If yes, then you'll need to increase the read buffer size appropriately via environment variables I don't have handy at the moment. An exact search for "Consumed more than 100000 bytes" will turn ...

I'd also point out that when you say "NAME1 is of length 25" you could very well be saying 25 bytes rather than characters. Oracle for example is typically set to "byte semantics", however you haven't mentioned the actual DB here.

Detail the settings you are using in the stage for us. Not sure if that will help but we may as well get as complete information here as we can.

You might also want to ask on a Teradata forum like this one to see what needs to be done in general to solve this.

There's no direct mechanism that I'm aware of in the tool to read emails. However, if you can find a tool that allows that kind of access you could certainly run it from DataStage in a Sequence job let's say and have it save the emails off somewhere that could then be processed via ETL. I don't know...

That's pretty simple, actually. Go to the appropriate forum and click on the Post New Topic link. It's at the top of any forum page listing posts and at the bottom on any specific posts you are in... like this one. FYI - I split this off to your own post in the General forum, feel free to ask your q...

An exact search for "logo" in this forum will turn up what look like a couple of solutions for you.

That all looks perfectly valid to me, process-wise. Only suggestion would be to try using a dash as the date delimiter rather than the forward slash so your timestamp ends up looking like this:

2013-01-31 11:03:52

More... standard.