DSXchange

Right, nothing magical about have 190 columns.

Different, don't know about 'better'. Or you could do the exact same thing there.

So yes, and it's all about Oracle not DataStage. Also note there's no need for custom SQL simply for this, I put the hint as part of the derivation of the first field and then the SQL will be generated all proper like, hint and all.

Not enough information for a cogent answer. How are you reading the files now - with a file pattern? Is that why you don't know the actual filename run to run? I'm assuming that, otherwise as others have noted you'd just use the job parameter that was passing it in. There's an option in the Sequenti...

An exact search for "64bit hash file" will answer your question.

Note, however, that it is actually a hashed file.

Why don't you throw us a bone before people go too far down the 'solutions' path? :? Are your values (other than the delimiters, of course) always/exclusively numeric? Will there only be one distinct delimiter in any given field and thus a single value always goes into B or can they be mixed and you...

I don't recall there being a "checksum" routine that ships with the product, are you certain this isn't something home grown? Can you find it in the Manager and check the source to see what it does?

That is what is known as a Very Bad Thing and something you need to resolve ASAP before you corrupt your repository. ps. The "Temporary File" location property in the Sort stage should never be left blank as that means they all go into the Project the job is running from. Always redirect i...

Errr... can you give an example or two?

Large job logs? Large number of files in your &PH& 'phantom' directory? Hard to say.

Try turning off the auto-purge for the jobs in question, see if that helps. There are some known 'issues' with auto-purge and MI jobs.

Are you current on all of the 8.1.x patches?

That would be a question for support, me thinks. Why not just set an appropriate length and move on?

As noted, you'd have much more control over things in a nice chunk of BASIC job control code, something that could automatically poll a job for the parameters it needs and then parse them from your flat file or a dynamic array. What Kim posted can be made to work for you if you know the names of the...

Pls let me know how I can do it. I'm sorry but what in the heck do you think we've been trying to do? Am I just talking to myself here? :? And while your requirement may be "simple", the solution - when it involves a variable number of parameters in name/value pairs - is not if you've nev...