DSXchange

I think that you would be best served to reinstall. A reinstallation would take just a couple of hours versus a lengthier period of discovery and any unknown error(s) in the future will attributed to the port change and you'll end up reinstalling anyway.

Option (2) looks like the correct way to do it. What happens if you use just one sort key (try both columns separately); does it work without an error or do you also get an error?

Hari - please use real English in your posts, we prefer not to speak SMS. You need a different version and that can only be procured from IBM or official provider. A straight download, even if available, won't have the requisite license key. There might be warez sites out there with this version, bu...

Sporadic problems suck, but once you discover the "rule" the behaviour always seem simple. When you look at the row counts after execution, you will have one stage where n rows go in and 0 rows go out. Which stage is that? One possible reason that comes to mind is doing something bad with ...

What are your Oracle NLS settings and have you specified that correctly in the Oracle stage?

The lesson should be "do not remove any files from a shell". Otherwise you might decide that you don't need that file called "VOC" or that all those RT_CONFIGnnnn are useless and then you will really become unhappy.

That is not what was asked, you can read a view from one database and write to a table or updateable view in another database.

The "dsexport.exe" command is found on your client, not on the server.

will remove the first character. or the convert command as listed above will remove double-quotes from the string.

Do you have an NLS installation and how are your Oracle columns defined - by character or by byte?

Wonderful idea and good luck on the project!

If you already have a transform stage, just use "In.DESC_TEXT[1,255]" or "LEFT(In.DESC_TEXT,255)". If you have a modify stage you'll need different syntax, which I can't recall off the top of my head.

Or use the ORACLE "substr" DML command.

It was interesting to read - thanks for that. I decided to open up a call and send it straight to Sunil or Len since I know that they know the answer without having to check but I'll probably have to fight my way through support first. I've already have been told that they can't help without knowing...

The more I see what you intend, the less I would recommend using orchadmin and the more I tend towards recommending writing a DataStage job to do this.

You can keep on declaring additional nodes until your job start so many processes that the system is overloaded. The configuration files can be located just about anywhere and the attributes are well documented.