DSXchange

U (the name of one of our posters) has not participated in this thread.

The correct spelling for the second person personal pronoun in English is "you".

Then use LIST.READU command to find out what kind of lock is held, and by what process.

One thing that can give this message is that the job is still open, in another Designer, or Manager or Director. Check whether this is the case.

Welcome aboard.

If the query parser is complaining about SELECT then there is something wrong with the table name in your UV stage. Can you please post the entire error message?

MS1252 is the "standard" "US 8-bit ASCII"

Yes, it can be done, but is not direct. It may be that a database to which you are connecting has a function (for example Oracle does) that you can use. Otherwise search the internet for how to code the conversion.

Why do you claim that control characters can not be handled by DataStage? I do not believe that that assertion holds, in general.

Even better, prefer -jobstatus to -wait so that you can determine the exit status of the job sequence without needing any further query.

How about RW access to the VOC file?

I have the feeling that ag_ram does not want to add entries to the dictionary, even though it's much easier if you do so.

You choose a directory (not a symbolic link) where you want to install the DataStage engine. You also need to provide a directory that can be used temporarily during the installation process. As you create each project, you specify a directory for its location. There are defaults for all of the abov...

... except that it's a server job!

As noted earlier, the only maps suitable for client-server use have "-CS" suffixes to their names. Try MS936-CS (Simplified Chinese) or MS950-CS (Traditional Chinese) for client-server communication.

You can do Min, Max, or Count on non-numeric data. You can NOT do Sum, Avg or Std Dev. Most of the other functions available also require that the data be numeric.

I'd still be checking tnsnames.ora file.