DSXchange

Ricky,

The only thing I can add to what Vincent said, is to make sure you backup your work. Don't make changes on a job that you don't have backed up some way [:)]

Good Luck,
Tony

You got me, buddy. I'm having similar problems with ODBC here, but they're constant. I'll start a new thread if we don't get it fixed soon.

Good Luck,

Tony

Hey Mark, DataStage ships with ODBC drivers (for Unix) for many common DBMS systems. I believe that SQL Server is among them. They don't have an Access driver for Unix, however. [:(] Assuming you meant DataStage project when you said UNIX server project. If you didn't mean DataStage, Merant (?) make...

Hey Steve,

I've got several jobs that mix stage types, like you suggest. Oracle OCI8 and ODBC stages all at the same time.

What is the message you're getting?

Tony

There is some discussion on the various options available in the hash file stage chapter of the Server Job Developers Guide, which comes with DataStage. In Windows, Start->Programs->Ascential DataStage->Online Manuals->DataStage Documentation. This will bring up a PDF file "menu". Click on...

nelc, Just wanted to pass along my findings with a similar situation... I had this exact situation and I found that I was doing a lookup on an external database (Oracle) and didn't give it enough fields to use the correct index, causing it to "table scan" the table for each lookup. When I ...

I've lead such a sheltered life. I never knew about the .NOTFOUND thingee. I've always used IsNull() or Not(IsNull()).[:)]

Tony

Ah, so there is a way to build an index encompassing all the fields that I need (composite index)? I figured that there had to be. I'll dive back into the Universe documentation. Maybe in the meantime someone will post back with the syntax.

Thanks Craig.

Tony

Just wanted to ask a question about another, ummm, "feature" that I found using this technique. When I have multiple columns that I need to join on in my hashfile/Universe stage, it runs slowly. It is slow even if I have indexes on each of the columns in the join. To fix this, I added a co...

Exactly what I needed.

Thanks, Todd.

Tony

Shivakumar,

I've just gone through a problem where the job didn't appear to be processing any rows. It turned out to be "slow lookups" because the fields that I was joining weren't indexed. Painfully slow. So, indexes do make a difference.

Tony

One of them is at:


Good Luck,
Tony

Vincent and Todd, I'm somewhat confused (I know, this is news? [:)]). Does the MQSeries plug-in work with Oracle Advanced Queue? I didn't think that it did, but after what's been posted here, I'm not sure. Vincent, how did you call the custom procedures to Enqueue the data (that's what I'm mostly in...

Todd,

So, you use an Oracle OCI stage to execute the Enqueue and Dequeue packages withink Oracle? Oh, wait, I see, you insert into an Oracle table and the trigger Enqueue's the inserted data into the AQ. Sorry for being slow. It's been an "interesting" day...[:)]

Thanks,
Tony

Just wanted to send an update along... I ran into this problem in another job. I was doing a lookup against an Oracle table. Because I needed to return multiple rows from my lookup link for every input row, I couldn't just use a hash file. I did end up copying the Oracle table into a hash file, and ...