DSXchange

Use following command
sort -u filename|uniq

Sort does not get rid of duplicate records, it only sort the file, uniq does the trick.

No luck.

Want to add additional information, I just installed SAP front end on my desktop yesterday, it all happened after that. And DS 6.0 is fine.

Hi Everyone, I have been using DS 7.5.2 for a month. It has been working fine until today. When I tried to modify my prevous code, when I click the input tab of sequntial file and Hash file stage, I got an error message 'Run-time error 1000, invalid action when bound'. After that, I could not even o...

Resolve the issue myself. Using DS Client installation executable, chose custom, then chose 'Multiclient Manager'.

Hi, I was trying to install this multi-client manager on my laptop, when I click the setup.exe, after choosing language as English, a dialog pops up stating Multiclient manager is preparing the installation shield to install, afterwards, the dialog disappears, nothing happened. What was the problem?...

Hi, I have this very simple job. DB-> outputfile It worked fine, while the number of rows is less than 25 millions, but it aborted after number of rows exceeds 25 million. All I could see on director is Abnormal termination of stage EWAR070InsertReceivable..OutInsert.IDENT1 detected. I'm using DS 7....

I see. Thanks.

Hi,

I browsed some of posts mentioning MKS Toolkit , we just installed 7.5.2, just wonder how I know we've installed MKS Toolkit or not. Also where I could find documentation of how to use MKS Toolkit ?

Thanks,

Carol

Hi,

We've just upgraded 6.0 to 7.5.2. One of our jobs was locked due to some reason, I tried to use 'Cleanup resources' to unlock the job, and found out this option is grayed out in director? Is there anyway I could turn on that option?

Many thanks,

Hi, We're trying to upgrade version 6.0 to 7.5, for a long period of time, we need to keep both versions. I already had version 6.0 installed on my computer, my co-worker installed version 7.5 for me on my computer, when asked upgrading to version 7.5, he chose 'No'. After installation, I tried to i...

Thanks for the answer.

The reason I'm asking is that currently we have lots of jobs using Trillium stages such as converter, parser, matcher etc. (the version is 6.X, ), we're trying to upgrade DS from 6.0 to 7.5, not sure whether the trillium stage will still work or not.

Hi, We are planning to upgrade our DS from 6.0 to 7.5, and we brought in an IBM consultant to show us the new feature of DS7.5. He told me that Datastage 7.5 does not support Trillium plugin anymore, because IBM has bought a company called 'validating'. It's going to use that tool for qualify usage....

Hi All, I'm running out of ideas. I'm having this complicated the job. The job processes a file row by row, (the order of the file content is also very important), depends on the value of incoming rows, it would go to 4 direction, each invovles a lookup and update or insert. The lookup table and upd...

Try to use timestamp(date()) instead of date()

Hi, I have encountereed a very strange thing. When I was trying to modify other developer's DS jobs,after I finished modification and try to save, an error message came back, says Unable to write record EWCD378EGASGCSHGdar to file RT_CONFIG4072 And when I tried to execute the job using dsjob utlity,...