DSXchange

Lookup-->Entire as a blanket statement? Yikes. To the OP - practice, experience and experimentation help.

Involve your official support provider if this happens to everyone. If it's just you, uninstalling and reinstalling the client may help.

Let me give you the short version - 3rd field from a dash delimited string. Walla! :D

(yes, I know that is not how it is spelled)

No-one can help you unless you can (and do) explain exactly what you mean by "special characters". By itself that statement means nothing, unfortunately.

Sorry, couldn't help myself. You run the installer, just like any other software... and kind of crazy, I know, but it comes with instructions.

"how to install Datastage 7.5.2"

ray.wurlod wrote:Fold() breaks on length boundaries, not word boundaries.

Phooey.

You would do this just like any other O/S command, depending on the need: Execute Command stage, Before/After ExecSH, DSExecute() etc etc. Many ways to skin that cat.

Hmmm... what "software" did you mean? I was thinking... server rather than client.

Any chance you could post the resolution? It could help future searchers who come here with the same problem.

So... no Folding? What the heck am I misremembering?

Hmmm... I seem to recall Ray mentioning the Fold() function for this but can't check at the moment.

Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release?

Forget about the viewer for a moment and just run the job. What happens?

ps. "Excel file" <> sequential file unless you've saved it as a csv first. Direct (native) access will require using the ODBC stage.

Either that or involve someone who knows how sqlldr works, someone like your DBA for instance.