DSXchange

Have to do a "Sergeant Schultz" on that.

No idea where (if anywhere) these details are documented.

Hopefully Steve Totman or Stewart Hanna will pick up on this thread and be able to find/provide your answer.

Maybe a Bourne shell script that does an su - username "command" where command executes your Bourne Again shell script. Might need a here script to supply the password value.

Well, why didn't you mention all that up front? Dammit, we've answered what turned out to be the wrong question!!!

Probably could also have solved this "new problem" with intermediate Sequential File stages.

Don't believe so.

But you could redefine them as, say, VarChar(20), add a field to identify the row number, and join back to the original data later if needed. Alternately you could define them as unbounded VarChar.

Take a look at the score to determine exactly what partitioning is being used. For example Entire on both links might well yield six rows.

Can you identify both boundary values for the range? For example if the lower bound is 0120 but the upper bound is 999999 then it is possible that 00120 might be the first or last key found and that then the row that is returned from the reference input.

What are the data types of the key matching columns from the main input (I am assuming this is a "range lookup on stream input")?

Administrator client, Permissions tab.

While you're there you can remove their DataStage roles, effectively denying them access without needing to change anything else.

4.) Using Sort stage, Transformer stage and Remove Duplicates stage.

Use fixtool (without a -fix option) to verify that the hashed file is not corrupted.

Invalid handle usually indicates some kind of connectivity problem, rather than any kind of data problem.

That said, I will almost guarantee that you can not use a Russian map to move Arabic data.

Character maps do NOT perform translation!

Can you please help me with full message I cant view I dont have the membership. No, because that would create a precedent of undermining a source of revenue that keeps DSXchange alive. Premium membership is not expensive, at less than 30c (Rs12) per day. If that's too much then, well, you ARE payi...

Floating point exceptions are very rare in the DataStage run machine. The fault type reported is actually the UNIX signal number (8 = SIGFPE, or floating point exception). The problem may be in your code and its interaction with your data. For example an attempt to divide a floating point number by ...

There is no difference whatsoever in terms of the information stored within them. It's purely a formatting difference. Some commands, such as dsjob -import or dsimport, (available in version 8 only) can only use DSX format files. There exists a conversion utility called xml2dsx to convert XML format...

"Put" is the generic function name for putting a row onto the output link. It is always (necessarily) reported by an active stage. Any time the passive stage on the other end of the link won't (or can't) co-operate to receive that row and do something with it, some form of "put" ...