DSXchange

Raju, One more vote for hash file approach from me. I have a job here that went from 10-15 rows/sec to hundreds of rows per second by converting all the DB lookups to hash file lookups. If your database instance is not on the same machine as your DataStage server, you have the latency of the network...

Mickey,

Ascential just released DataStage v7.0. It is reported to have web service functionality. I'm not sure whether this will allow you to feed data to your web service interface or not, but it's worth a try.

Good Luck,
Tony Stark

Guillermo,

It is reported that DataStage 7 will allow you to build a job that will sit and run and process data as it comes in. If I understood it correctly, this is implemented as a "web service".

I am anxious to see DS v7 to see other new features.

Tony

rajeev,

We had a discussion about this very topic within the last few months. If you search the archives, I'm sure that you will find what you're looking for.

Good Luck,
Tony

SBN,

I doubt it. Several folks on this forum have told of problems with DataStage v6.0 running on Windows Server 2003.

Good Luck,
Tony

Ray and Vincent, thanks for your replies. (me putting on my stupid hat)[:D] I figured it out. Problem 1 was that I didn't understand that I would essentially have one field coming out of the XML Output stage containing all the XML for one row. Problem 2 was that I needed an output link from the XML ...

I need to generate an XML file, where - each line is a properly formatted XML document - each line is terminated by the appropriate new line char I spoke with an Ascential rep and was told that this requirement wasn't normal. He suggested using an XML chunk and perhaps having a "pass through&qu...

Kenneth,

I thought of that briefly, but didn't make the connection that you proposed. Good thinking.

Is there an equivalent in Parallel extender? I suspect that may have been where that comment was directed.

I appreciate your reply.

Tony Stark

I recently saw a statement that it would nice if DataStage had a continuous reading funnel. Does anyone have any idea what that might mean? I couldn't find anything meaningful on Google about this.

Thanks,
Tony

Hi Johnno, If you set the query type to "column generated", then click on the build button, you'll see the "From clause" text box. You can put the table name in there. Then change your query type back to what it was. You may want to copy the SQL before you do this, if you're usin...

I had our administrators install the XML Pack 2.0.1 on our server (HP-UX v11, DataStage v6.0.1). They got error messages during each of the three parts of the install. They all followed the same basic format: Changes made to project SCM: Registering PlugIn xmlienu.sl. /usr/lib/dld.sl: Call to mmap()...

Kim,

I suspect that Craig's just a bit "further out in front" than I am and I haven't run into this yet. [:)]

Good Luck, Craig. Sorry I can't help you on this.

Tony

Good idea about diff'ing the DSX files, Ray. I'll try to do that on Monday when I get back and let you folks know what I find. I think the keys were defined correctly. Again, I'll check on Monday and let you know. Craig, I _should_ be working every day until we get done, but I just don't have enough...

Hi Craig! I appreciate your reply, especially on the weekend. Nothing special about the first row that I can see. I copied the job and went to work on the copy. I deleted the transform stage and re-added everything by hand, taking care not to copy/paste anything from the original job. Of cource, now...

I have one job that does lookups against several hash files. On one of the hash file lookups, the transformer appears to read the first source record (the record count on the input link stays at 1), then generate about 100,000 lookup and output records, then the source record count moves upward from...