DSXchange

I know, Uncle Ray, I know...

But you don't need all 5 million rows in the reference lookup, now do you? You just need how ever many match to your incoming records - and you said that's what, 30? Get smart about how you load things like this. Load your input file into a work table in your database and join it to the reference so...

The only other stage that allows a 'multi-row result set' is the UV stage. Probably best to just 'tune' your ODBC lookup to be as efficient as possible. Do you have an index in place to support it?

You cannot just add the "path" to the the statement, as the syntax of both calls are different. Actually, you can as that's exactly what I've done here and it works just peachy. As noted, the syntax to call the routine is slightly different - you need to pass in the full path to the hashed file rat...

If your mission is to go around and correct all of the spelling issues here, you'll be a Top Poster in no time. No problem with hitting old posts, some will do that if the issue was unresolved, others just because they have something to add. It does help enrich the site for searchers, even if the OP...

So, you copied the routine and the only change was from Open to OpenPath, yes? If that's the case, then the problem would not be with the routine itself but how you are calling it.

Can you provide an example of your calling syntax, please?

Count the number of left and right parens...

I believe that the Java PACK is your answer for both here, but would need someone more smarter to confirm or deny.

The Manager is a Client tool and so can only 'see' local files on your PC. The solution is simple - transfer the files to your PC first.

Ah yes, I've had this bookmarked for some time now. And yes, it seems to be quite "up you're alley".

It's very confusing, I remember having the same problem the last time I installed the MCM but don't really recall the solution as it's been quite some time. I do remember smacking myself on the forehead (doh! <smack>) when I finally made it work.

I do believe Arnd is right.

ray.wurlod wrote:There's no Trunc() function in DataStage BASIC.

Isn't the INT function an equivalent? Sure, it doesn't have the precision option as shown, but basically (no pun intended) it truncates a 'numeric expression', yes?

Interesting... not only did you reply to a pushing one year old thread, but this wasn't my "problem". And no, there is no "must" in using the Inherit stage properties option, you certainly can but not there is no "must" here. And inheriting bad metadata from the Stage tab wouldn't be all that helpfu...

You wont be able to change it directly there. You need to define a parameter in the job sequence and pass that parameter as the value. Plus for encrypted passwords, you wont be able to "double click" and enter a value, you need to hit "Insert parameter" and then specify the job sequence's job param...

In the job sequence, when i double click on a string parameter i can edit the value. When I double click on a encrypted parameter, nothing happens... don't undestand... Me neither. Nothing magical about Sequence jobs, our Production support peoples do this all the time. Matter of fact I just did it...