DSXchange

The short answer is an emphatic "no".

What is the use of @False in this expression I'm guessing someone added it (as part of their debugging / bottleneck investigation) to shut down that link... and then forgot to remove it later. Or are still investigating. Or that link no longer needs to ever send rows down it and they wanted to pres...

What you posted is hexidecimal. For example, "30362f30312f32303131" is "06/01/2011" so your first task would be to that to character, it would seem.

Have you tried trimming the leading zeroes from the final string?

Blame Richard Pick.

From what I've read, he chose it because you can take the modulus of the date and determine the day of the week. No clue if there was more to it than that.

when making ldd ./oraoci9.so the message appears: unable to find library libclntsh.so.9.0 When you are executing this, has your user sourced your dsenv file first? And if "sourced" is a new term for you, it means doing this first: cd $DSHOME . ./dsenv To set up your command line environme...

Read your Planning, Installation, and Configuration Guide pdf, they're all listed there as well as everything else you'll need to know.

You could also start here if you don't actually have 8.5 in hand yet.

No... note that the individual values within the string are being re-ordered ascending. There's no simple way to do that. Can't even think of a complicated way right now.

How are you performing the math inside the job - convert the string to a number, divide, convert back to a string?

A Folder stage at the end of a Server job would handle the '10 files' and the naming you are looking for. Switching to an XML Ouput stage with a 'Trigger Column' gets you part way there... 10 files, but without the level of naming control you are looking for.

You'll first need to implement what Ray noted simply to be able to read them as a single record. After that, you can do whatever is needed to remove the LFs if you still feel the need, including the Convert() that you posted.

What makes you think you can't do multiple statements in the Execute Command stage?

pandeesh wrote:As of now I am doing rm-f for removing dataset.

Bad boy.

Bottom line, this is either a dsenv issue with the Oracle related entries or some incompatability with the "bitness" of things, mixing 32 & 64 bit executables, for example. Since we're assuming that none of that changed during your upgrade, I'm still focusing on your dsenv file because...

You didn't answer my question... and I meant the "error in dlopen" message.