DSXchange

Hi Ernie,

Do you happen to know if that rule (about the locator) is documented anywhere?

Yes, but there's still more that you must do, including bind. There is a manual on DB2 connectivity - reading it will benefit your understanding.

What mail client have you installed on your DataStage server?

It does seem likely that the fact that you can't ping the SMTP server is the root cause of your sendmail problem.

I get this problem on a daily basis. It may be because I have a larger number of posts, and posting.php updates indexes the hard way. Whenever posting stalls, I return immediately to the forum (using the navigation list just above "Post a reply") which avoids multiple posts. The post is ma...

HOW is the problem solved?

Was it that the data type of COL1 was not some kind of integer?

In any case please mark this thread as Resolved using the green button at the top.

If the files are of different format, how do you propose to process them all (parse them) in the same job? You are correct that you can read them using a single VarChar column, but what happens after that? Is there some trigger in the data that you can use to indicate how to parse that particular re...

I'm going to assume that USTCAX008 is your SMTP server as mentioned in your routine. The error message states that this server can not be contacted. Perhaps you should check whether this server is, indeed, accessible from your DataStage server.

Parallel Transformer stage variables are implicitly NOT NULL. You can not have a stage variable expression evaluate to NULL.

ODBC protocol does not allow for an unbounded VarChar (that is, a VarChar with no maximum length (precision)).

The date format string must exactly match the string, including any delimiter characters. Try: o_date=date_from_string[%yyyy-%mm-%dd](a_varchar) However, if the output field is of data type Date, then the conversion is to a date, which is a binary quantity. The only time you get a format is when the...

The Metadata Repository option gives access to the shared tables.

OK, I've managed to track it down. Details follow. Just stumbled on this - happened to catch one in a list of processes. Obviously the $DSHOME/dsenv script needs to have been executed first. You need to be attached to the project directory. $DSHOME/bin/uvsh "DSD.CompileJob jobname FULL" Ha...

When you get to 8.1 or later, you will be able to use istool (Information Server Manager) for this functionality. It is available server and client side....

Ankur_KapoorUK wrote:As suggested by u ...

U did not suggest anything in this thread.

The second person personal pronoun in English is spelled "you".

Microsoft don't call them patches. It would be a "service pack". The spin's the thing!