DSXchange

What indexes exist on the table? In particular, is the "Key" column indexed? If not UPDATE will need to perform a table scan for the key of each value being updated. You would find this difference no matter what tool you used. It's an artifact of how databases work. In particular it's nothing whatso...

To use QualityStage you would either need to adapt the xxAREA rule set (make a copy, since the original is read-only) or create a new rule set. But what is "standardize" in this context? I'd plump for using DataStage, since there are really only two formats - decimal degrees or degrees, minutes and ...

Search

This has been asked a bajillion times in the past. Or is it a bazillion?

They are NOT "boxes or brackets" - that's just how the tool you are using to display them represents those particular code values. View Data in DataStage is notoriously bad at displaying non-ASCII characters - it usally just gives up and displays "?" to indicate unmappable character. You need to fin...

No. Not using -local.

Is that all there is in the error message?

An arithmetic overflow occurs when the size of a number exceeds the size of the data type designed to store it, for example when a signed integer exceeds 2147483647.

Of course, this does not include any hashed files you may have created on other file systems for server jobs or any disk and scratch disk resources you have on other file systems for parallel jobs. Totalling all of these presupposes good record keeping.

DataStage (WebSphere) TX version 8 client software?

If not, you have posted your quetsion in the wrong forum.

(In version 8) you can simply right click when testing the match specification and look at the individual field weights.

I'd have to research how to do it in version 7.5 and earlier, but recall that it can be generated in one of the reports.

You do get a Sort link marker (unless, of course, you disable display of link markers).

You don't export INTO executable jobs. Though you can export executable jobs (also called job executables).

Time to mark the thread as Resolved then, and for Craig and I to accept some scorn for not spotting that. The tokens in the string must match the tokens in the template (for example "from:" must match "%from%".

Well done.

Did you try anything different?

Did you try including the SMTP server name?

Add SUPPRESS COLUMN HEADER to the query. SELECT EVAL "CONVERT(@FM:@VM,'~|',@RECORD)" FMT "132L#132" FROM hashedfile SUPPRESS COLUMN HEADER; @RECORD is a system variable containing the entire data record (without the key column(s)). The CONVERT function converts field and ...