DSXchange

I can't seem to find an answer to this in the forums, but I'm sure someone must have run into this issue before. In an Enterprise job, I need to subtract a given number (the UTC/GMT offset) from a timestamp field, and return the new timestamp. It doesn't appear to me that any of the built-in functio...

I have a requirement in which if a duplicate value occurs in a particular field, I need to drop both (or all) of the records with that value. I'm guessing there may be a sql statement that could be devised to handle this, but I'd like to do it without that if possible. Anyone have suggestions? Thank...

I've been trying to understand the use of DSSetJobLimit within a server job, and I seem to be reading some conflicting ideas. I have simple server job which I need to abort if it produces one warning. (Our project default is 50, so I need to override this.) Within that server job (which will be run ...

We have IA 8.0.1, and have had it installed for a while, and are just now attempting to utilize it. I'm attempting to create a project, and in the process I need to add a data source. I select our Development server from the list of sources, but when I select 'OK' to add it, I get a Registration Err...

Here's an update - it appears that our problem was caused by a patch that IBM created for us for an unrelated issue. The unrelated issue was a heap allocation error we were getting with a particular EE job that read small sequential file. The patch fixed that issue, but apparantly caused the issue I...

Ernie - Thanks for your reply. Regarding server vs. EE - it's actually kind of both. We would prefer for the job to be strictly EE, but were told by IBM that the Websphere MQ stage and Websphere Connector stage wouldn't work in v. 8.0.1 (which is our version). And previous testing we've done seems t...

I'm wondering if anyone else might have any suggestions on what to look for with this issue - In our Dev environment, it appears that all of our jobs that read an MQ (with the MQ Stage) are behaving as if the "Commit/Backout only once at the end of job" flag is checked - and it clearly isn...

ArndW -Thanks for the reply. My understanding is that the DataDirect drivers are bundled with DataStage. So does this mean you connected to MSAccess with those? Thanks.

Tom

I've seen several posts where users needed access to an MSAccess database through DataStage. The answer usually seems to be that some 3rd party ODBC drivers are required. What I'm wondering is if anyone has actually been successful with this type of connection, and also if anyone has any more specif...

I'll consider it resolved, and mark the thread as such. Thanks everyone for the information and suggestions.

Tom

Ray -

Building on your suggestion, would it make sense then to have the Wait For File stage flow to the Execute Command stage, which would execute the DSStopJob command?

Thanks.

Tom

Thanks guys for the replies. Kryt0n - If I'm understanding correctly, I'm not sure that solution would work for me, as there is no real end to the stream of messages. They can come in in any order, throughout the day, or not at all. Ray - I think what you're suggesting would work for me. I'll give t...

In our environment one of our DS jobs basically runs 24 hours a day. It reads XML messages from MQ, parses them and loads the data into an Oracle table. I've now had a request to schedule the job so that it starts at a certain time of the day, and ends at a certain time of the day. But so far I have...

Thanks Ray, I went with your first suggestion, and that worked for our needs.

Thanks again.

tom

I haven't been able to quite find a solution in the documentation or forum. But I think what I need to do should be pretty simple: I need to convert the time portion of a timestamp (housed in an Oracle database) from 12 hour to 24 hour for output. For example, 2009-02-23 3:42:29 PM would be 2009-02-...