DSXchange

Is this PC on another network? Can you go to a DOS windown and either ping or tracert or telnet to the server machine?

Yes , I have specified three columns as key columns . The duplicate records are DOYLESTOWN}PA}18901}ADDR_DIM DOYLESTOWN}PA}18901}ADDR_DIM The first 3 columns are specified as key columns. Hashed files are unable to have duplicate keys; so either you have embedded spaces or undisplayed characters in...

You haven't been very clear about exactly what your problem is, but here's a guess at 2 possible answers:

1. use "cat" to concatenate all 3 files to one file and process that one.
2. Use a loop in a sequence to call a job, passing each file name as a parameter to the job

Umberto, you can connect using ODBC "localuv"

Archana, a hashed file key is unique. If you specified all 3 key columns when you wrote to the hashed file you cannot have duplicates. Are you certain you specified all 3 columns as keys for the hashed file? If you are certain, could you show an example of a duplicate record?

Vincent - so am I, now that you've said it. I was waiting for a long weekend for me to go through the docs again and I was worried I'd have to link something external into PX in order to get some of the questions right. Phew, now I don't have to worry about that part.

Since this problem was caused by inadvertantly doing something that shouldn't have been done in the first place and many of the steps touched upon in this thred have the potential of breaking not only a single project but the whole installation I would not feel comfortable describing all these steps...

OK, but keep your posts less complex to answer. Your original post needs a lot of time to answer, you posted about 8 different questions at the same time - we are volunteers here. The difference between the normal KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent is that the first routine is meant...

Thanks - I'll be happy to reach 5K and retire happy.

I just assumed that "Batch" was something outside of DS. I agree with what Ken stated - it was great to program your own batch inside of DS because there were no other options. I still use that portion occasionally to manually start one job from the before-part of another. At 7.5 the rich sequence p...

Correct, nobody is answering (so far). Part of the reason that I am not interested in doing is that you mixed questions and statements and said you have "doubts". Another part is that the source code is available for you to do your own research. For example - could the difference between "KeyMgtGetN...

I still don't know where to draw a link between batch jobs and sequences. A batch job is external to DataStage and a Sequence is internal to DataStage. It's like asking what the differences are between a shell script and an executable in UNIX- they both have an area where their functionalities overl...

I wish I knew what a job batch was. Could you narrow that part down a bit?

Write a job that loads your to-be-included file contents to a hashed file, using a key 'B':@INROWNUM as the key and just one column with your contents. In the same job read your source file and write to the same hashed file using the key 'A':@INROWNUM until you hit your trigger "Harry" and then chan...

Your metadata for the table in the Manager does not match your actual table. reload the table's metadata from the database and use that.