DSXchange

Search is your friend!

Found this post with both the same problem as you are seeing and a solution as well. Hope it helps.

Now, there's a doughnut worthy suggestion!

What does your target table look like? What kind of errors are you getting? Your biggest problem is going to be the fact that 30,000 is way too big for a single field of any normal type. You need to go with something like CLOB on the Oracle side and then you'll find that DataStage doesn't really han...

FYI - there is a solution for this issue from Ascential. They shipped me a 'patched' version of the DSSendMail.B module and I was able to send emails from 7.5 without having to run the job under the administrator id.

The eCase is 60747 if anyone else is having the problem.

You looking for help designing a job or a table?

Count the number of delimiters. Use that count in conjunction with the Field function to always get the 'last' field.

Do it all at once like this:

However, using the Protected project with the .dsx approach for code migration is the only way we can get the code to be in a read-only state. Version Control will do this for you automatically without having to use a protected project. And about the release information appended to the job name, we...

With Protected projects, we found out that the users belonging to the role of a DataStage Operator only have access to the Director. In addition to that, the Operator can only execute,reset jobs and view logs in the Director if the jobs are "released". Why is that so ? No clue. I think that all we ...

Have some more tuna.

So, what made it work for you? Best to post the actual solution so that others can learn from it. That and so we can settle Ken's donut dillema.

Post an example (or two) of what your data actually looks like. It must not be in Timestamp format after all.

Not sure what to tell you as this should work fine - as long as you have data. I threw this into a scratch routine and it subtracted the two timestamps just fine. The only time I got a zero was if both were the same or if both were blank. Any chance of that? Have you run your job through the Debugge...

Ok, that seems fine. It looks like you are using Stage Variables rather than a custom routine, is that correct? Can you cut and paste the actual derivations you are using, please and use the 'code' tags so they format nicely? It always worrys me when someone says "I'm trying to do something like thi...

What exactly do your date fields look like?

Work tables.

If you can't find a way to work this out all in DataStage, break it into a couple of pieces. First job transforms your source, does your Quarter Hour thing and then loads it up into a work table. Then you can do the union minus thing after that.