DSXchange

tunde,

There is a transform under TransformsSDKKeyMgt called KeyMgtGetNextValueConcurrent

I can't see why this wouldn't work on a parallel job.

Good Luck,
Tony

Thanks, Vincent. That's more than I knew about AQ. I'll look into it when I have a minute...

Tony

Does anyone know if DataStage will work with Oracle Advanced Queue? I see a plug-in for MQ Series and I've seen literature on DataStage and another IBM message queueing product (something about Websphere, I think). I haven't seen anything about it being able to use Oracle Advanced Queue.

Thanks,
Tony

Too late! They put it back in... kinda.

I'm going to have to study this and make sure I know EXACTLY what they want before I start coding on this...

Tony

There are EBCDIC to ASCII transforms in DataStage as well...

Tony

Well, as of a few minutes ago, the requirement to calculate the entire QPA of the entire product was removed. Apparently, the data is incomplete, so all they want is the current part QPA * the NHA QPA. I can do that. For the archives--- I decided to take the original part info and put it in a hash f...

Hi Steve, Thanks for the reply. Unfortunately, each part can have multiple next higher assemblies. And, at this point, at least, I'm not sure how to tell if I have bottom level part, or not. I'll read through your post a couple of times and make sure that I understand it, to see if I can adapt it to...

Thanks. As soon as I have a minute to look into this, I'll look into it.

Tony

Hi Vincent! I am considering lookup stages for each level of NHA. I hadn't considered shared containers (I've never made one work in v6.0). That's something to think about... I'm not sure of the maximum number of levels at this point. If I can get my users and analysts to admit to a reasonable numbe...

Thanks, Craig. We're using Oracle. I'm not real experienced with Oracle, but the suggestions that you've made make good sense to me. I'll look into them. It is only one table (I think). A function or stored procedure sounds like a likely solution. I guess I was in the "if i only have a hammer, ...

Hi all, I've got a situation where I need to calculate the number of parts in a product. The product consists of a number of assemblies. Each assemblies may consist of other assemblies. Each of these assemblies will consist of one or more parts. From the part perspective I have a quantity per assemb...

Yes, we were doing a lookup across the network (to the Oracle server). I think the guy that wrote that job did end up loading that table into a hash file and doing the lookup that way.

It was pretty weird that we couldn't see any data going through the job, though.

Tony

I think that's what he ended up doing.

He started the job yesterday,with the database lookup in it and just let it run (accidently). It took 23 hours and 40 minutes to process 12,xxx rows. In the meantime, I think he re-wrote the job the way that you mentioned.

Tony

Thanks, Creo. That was my exact recommendation to my co-worker that brought this problem to my attention. Glad to know I'm not completely off-base.

Best regards,
Tony

That might be the answer to speeding it up, Steve. I just looked at the job a minute ago. It has been runnning for almost 24 hours and has processed 12,xxx rows. I think the problem is that the lookups are just taking a loooooooonnnnnngggggg time. So, it actually is processing rows, just very, very ...