DSXchange

shiva_reddys447 wrote:please find the below inforamtion which differentiates JOINS LOOK UP and MERGE stages.
may be bit tough to read(format)..

Use Code tags for fixed-width format.

Were you aware that IBM owns copyright in the manuals?

Why are you advocating that U follow the example? U did not ask the question.

Milliseconds, even microseconds, can be handled via the format strings. The examples you provided in the original post contained no fractional seconds, which is why Craig answered (correctly) the way he did. And, yes, the technique is documented in the Parallel Job Developer's Guide - search out "fo...

... or it could be UV_SCHEMA or it might be VOC or it might be a host of other things. So many maybes. You need to know what the helper subroutine is trying to do.

Use the Save and Load buttons. Avoid using the Saved category if you want to preserve these table definitions. When loading, leave the "Merge metadata" box checked.

Use -jobstatus OR -wait, not both.

You do not use $PROJDEF in the Administrator. You set a "proper" value in the Administrator. You use the special token $PROJDEF as the default value of an environment variable job parameter. It does not work with standard job parameters.

The GUI (Manager in version 7.x and earlier) allows you to select just a category. There is no command line equivalent.

Search the forum for discussion about parallel jobs not being able to handle the conventional "" meaning a single double-quote character within a double-quote quoted string. The string "Little Wood" in your data fits into this category.

For this one you need someone with access to the source code of DSR_PROJECT (a helper subroutine) to find out what Action 1 is. That means your official support provider will need to be involved, since IBM does not release source code they will need also to be involved - through your correct channel...

You also need to have GB2312-CS map built and installed on the server. This is the map it uses for client-server communication.

Edit the post(s) and check Disable HTML

Set the encrypted environment variable in the Administrator.
Set up the job parameter so that its default value is the special token $PROJDEF - this tells DataStage to use the project value you set up in the Administrator.
Don't mention the job parameter in your dsjob command.

Why not? 0 + 0 = 0. Even 00 = 0. That's the calculation for my bonus, anyway. My boss is the epitome of parsimony.

(Yes, I am self-employed.)

What format string are you providing to the StringToTime() function?