DSXchange

So... just the client was installed in French? Worst case could you not uninstall and reinstall it in English? I be surprised if you could just 'flip' it to a new language but who knows, perhaps you can... been surprised before.

I was wondering why you started this one. Just go there and "Delete this post" before someone replies to it.

Yah, nice to mention "2 params" and then not name them. Here's a thread with the details:

viewtopic.php?t=125607

This has been asked and answered a jillion times here. Another way - create it with a fixed name and then rename it to include the date 'after job' using your O/S.

True.

Across boxes? Thinking you'd need to zip/tar the folder, transfer that and then unzip/untar on the other side.

That syntax looks... wrong.

Get it working from the command line first and then 'wrap' it.

A 'folder transfer', meaning a directory and all of the files it contains? Not an ETL task, but you could 'batch' it and then DataStage could run the batch file.

springwtr wrote:Also, I use this function and assign the derivation to a column in the job. Regardless of what column I assign this function value to, Userstatus is set in this job and is available to next job activity in the sequence. Am I correct?

Yup.

Because your VARCHAR2 columns are defined as a number of bytes when (for multi-byte character sets) they should be defined in characters instead. X characters does not always fit in X bytes as you can can see from your errors.

As Ray would say, that's a problem that is easily solved. A Premium Membership would quickly pay for itself with the time it saves, you could have had this 'problem' solved within moments of coming online and searching. Heck, that's why I paid for one for the last three years. Did you try the search...

By "posted routine" I meant the UpdateUserStatus routine code that Ray posted in this thread. If you do an exact search for "Call DSSetUserStatus(Arg1)" you'll find that various incarnations of it have been posted close to a dozen times in these forums, most include explanations ...

You assign it in the current/same job using the posted routine and then you reference it in any downstream job or activity.

It's optional, so you need to select it during installation. If you missed it, you need to rerun the Server installation and go into "maintenance mode" to add any unselected ones.

Sure, but the number of people actively using SAP is on the small side I would wager and it's something I've never personally seen or touched. Have you contacted your official support provider in the meantime?