DSXchange

Welcome aboard.

How about dsjob -logsum (summary)? There is no single command that will get you the full detail of the entire log, in much the same way and for the same reason that you cannot do it in Director.

uvsh and dssh are the same (one is a symbolic link to the other).

The uv command is a wrapper that can tidy up the connected user's private shared memory segment, and perhaps decrease ulimit, before invoking uvsh.

If you can find or write a Java class that reads from an Exchange server, you could use a Java stage to invoke that class. Similarly if there is a web service associated with your Exchange server, you may be able to invoke that using a Web Services Transformer stage.

The Lookup stage also offers an option that permits return of duplicates on one reference input link. But it is disabled by default.

Not all ten digit numbers can be integers. The largest possible signed integer is 2147483647, the largest unsigned integer is 4294967295. It's that fact that triggers the alert message. Any number larger than these will wrap around and be reported as negative. What are your actual values?

Information Server Manager is to be preferred, because it gives you the ability to create versioned "deployment packages" and to interact with source code control systems if that is your wish. Table definitions do not need to be promoted (though it's not wrong to do so); when you load a ta...

Yes.

The difference is when.

The lookup table (LUT) for a Lookup File Set is created when the Lookup File Set is written to. If any other stage is the producer for a reference input to a Lookup stage, then that LUT and its index is created at run time by the LUT_CreateOp operator.

Are you sure that the job is failing due to overflow? Or is it that you are getting a warning that mapping float to integer may cause overflow, and the actual cause of failure is something else?

All VarChar data types should be quoted by default. Can you open the extended properties of that particular column and see whether there is anything there that might change the default? You might also be able to see it in the record schema.

That is correct under the CSV "standard" specified by Microsoft; numeric values are not quoted. To achieve it, simply change the data type to VarChar.

You can declare it, but the field better contain a valid decimal value. See Chapter 2 of Parallel Job Developer's Guide to learn how values are represented, or the reference that James provided. Given that you are in France, is the decimal placeholder defined as ","? That might also invali...

The spacing of characters in output is deliberate, so that non-printing characters can be indicated by code values, for example an embedded tab would be shown as {P A T T Y 09 C A K E} (so Craig is correct). Another idea I have is a liking for my sleep. You posted at 3:56am my time. You can, of cour...

You can download and install version 8.7.0.1 (that is, 8.7 with Fix Pack 1 pre-installed). This will save you some time.

Why don't you show us your exact working? Grouping columns, calculation method, output column names and data types, and calculation functions. It is not permitted to sum a VarChar. Nor is it meaningful. Convert to appropriate numeric data type upstream of the Aggregator if the string contains only n...

"a" formula (not "the" formula)

Square brackets are not supported in expressions in DataStage, though your intent is clear.