DSXchange

I am glad you were there then

So overruns actually meant over-loads. If you are satisfied with the answers and have a clear direction of action, you can mark the thread as Resolved.

The odbc stage has an option of creating table. It automatically creates the ddl. It should work with the metadata retained on the link. What problems are you running into ? Did you hit the button that says, create ddl? As far as i remember, there is a "generate ddl" button in odbc stage. Check it o...

It would. Thats what i said, "how much a processor can support", rather then what kind it is. A 4MB can support more than a 512KB.

I really doubt processor type matters. Its actually the processor speed that would make a difference. For applications like DataStage, it would really depend upon how much the processor can support rather than processor type.
My 2 centy.

What do you mean by overruns. If you mean re-running the same job then it depends upon what option you specify. For example for hashed files if you specify "clear file" then it will do as it says, clear the file and then load it again.

I prefer Bruce Almighty

Welcome Aboard Kim

Yes the Stored Procedure Stage. But wait, I dont think STP stage supports SqlServer. Use the ODBC stage.

You have STP stage in your version. Use that stage. Send in your parameters as input and specify two columns as output. Read the documentation for more info.

Great work Ken. I bet this will avoid all that typing and explaining.

I was indicating more towards the vast parsing capability of shell's and utilities like awk.

I designed something like this for one of my clients sitting on a server engine. It was from a flat file. I had multiple instances of the same job. Each time getting records from the same file but in sets. If i had 5 instances of a job, the first instance would select 1,6,11 and so on... records; th...

Plus it may/will seize to work in version 8.0. Maybe you need a different approach. Only if you were sitting on a unix box. This would have been much easier.

Neat. Thanks Ray.