DSXchange

If it only happens to you on your PC, then it could be your client installation or your workstation itself. First try a reinstall of the client right over the version you have out there now and see if that fixes anything, sometimes dlls get updated by other software and this puts things back the way...

Are you sure you uninstalled everything, including any filesystem cleanups you may have to do? Still think you should be involving your support provider.

... and a newline would be represented by CHAR(10).

Oh, I'm sure it's possible, a script is a script after all and that's where they run. I just don't see the point in worrying too much about it. That was probably how it was all done in the Old Days when Torrent Systems marketed Orchestrate, which is the product Ascential bought that is now the paral...

Sorry, I was being somewhat facetious and serious at the same time. You "run the script" by running the job and the job runs the script along with everything else that it does.

Why are you thinking you have a need to call just an OSH script?

You would run the OSH script using 'dsjob'.

Some kind of installation issue, I would guess. Probably best to involve your support provider on that one.

devesh_ssingh wrote:Why have two similar posts?????

Because the first one was in the wrong forum and I asked them to repost it here.

What are you asking?

The filename is literally "DSParams" and the location has been spelled out for you as well.

What, now you're not being helped?

Check the running user's .profile and see if that is the culprit.

No, you cannot. It's an artifact of how the value is returned, something you have no control over, which is why I said it needed to be stripped afterwards.

You are missing much more than simply the ORACLE_HOME and what little is there is in a different order. Seems like something else is overriding that LD_LIBARY_PATH setting.

"an error"?

You need to convert() after the routine call and where you are using it, typically in either a trigger or parameter derivation... or nested condition stage.

Suggest you post this in the proper forum, a.k.a not here. The General forum seems the most appropriate.

**Note: Topic Relocated - Content Editor **

OK, that looks fine, return-wise. Can you post the LD_LIBRARY_PATH value from the log entry that lists them all? Just that one line, not the whole darn thing.