DSXchange

The dsjob executable is a standalone, if you call it with the appropriate parameters to the actual server machine it will call up the job on that host. You can always do a "rexec" as well - since you would need a user-id and a password to login on the remote host in any case.

Mirja, in a transform stage that writes out to your table, put another output link for your rejects and reject handling. You have stage values for DBMSCODE, LASTERROR, REJECTED, REJECTEDCODE, SQLSTATE to choose from. This at least lets you identify the errors and separate them out. What exactly do y...

You mean like "Character string truncation" warnings? (this is a harmful one) or "Warning: column name does not match SQL name!" (which might be harmful)? You can enter TCL or use the ADMIN tool and do a "SELECT * FROM DS_RESENU;" (or "LIST DS_RESENU" for non-sql type query) to get a list of the mes...

I can't think of any warnings in Server that need to be suppressed and are not harmful. PX jobs are different, but one can't just give a list since each warning is potentially harmful if not handled correctly.

Again, server jobs should be designed to not issue any warnings.

That sounds like a very odd problem. If you make your sequence changes in the designer and compile it, then look at your job control tab do you see the new/modified stages? What happens if you do a save-as another name or copy it and recompile it?

The lookup generated more than one return row.

Put a link to a reject sequential file in the transform stage where you are loading to DB/2. Use the contstraints to push links out to the reject (click on the "..." button to get output variables) as well as to choose which database information to write.

Just click on the colored text, it should bring you straight to the post. At least it does when I cliock on it. You could also try browsing the FAQ for a subject titled "FAQ Suggestion: How can the director log be output to a file".

I started to put a shell program together and then realized that certainly this has already been described - click here to the get FAQ answer to your question.

Vinod, unless you are using DSXchange from your telephone or other PDA without a full keyboard, I would be very appreciative if you could write It would be great if you could help me out on this... Thanks for your prompt reply instead of It wld be gr8 if u cld help me out on this... Thnx 4 ur prompt...

Vindodand, I assume you mean "let me know" when you posted "lemme knw". There are two main ways to do this and both involve a bit of work. If you like shell or batch programming then you can use the "dsjob" executable to get a list of jobs in the project and then list out their log file contents, yo...

Jaydev,

that is odd, I tried searching for all terms "appears not to have started after 60 secs " and got 12 threads as a result.

No, it is not. The excel format needs to be parsed. Either create a .csv (comma separated variable) file from the Excel sheet(s) or declare the Excel as an ODBC data source and use the ODBC stage to read it; this will only work on Windows server DataStage. On UNIX your option is only to create a tex...

The basic concept is the same in server as it is in parallel. The random method will use the system's internal pseudo-random number generator to give a good distribution. A sample of 12 records is too small, if you had 1000 records you would most likely get a relatively even distribution, the higher...

Trim also works for Char... Kumar, what does TRIM() on a CHAR(10) field containing "hello " return? For a char field Len(Trim(field_name)) will return the count without whitspace. Kumar, doing a "LEN(<char field>)" does an implicit conversion to VarChar, which is why it works. A Char column has no ...