DSXchange

Pipe the result through grep -v Status code =

The system administrator seems to have restricted the use of the chmod command. Exercise your negotiation skills!

Do you have Not(IsNull(keycolumn)) as (part of) the constraint on the update link?

Welcome aboard. :D If you read through the information you will discern that a null pointer (a pointer to memory that does not have a valid memory address) has been generated somewhere in the Java. You may have omitted a mandatory property, or there may be a bug in the software. You can check the fi...

Use ANALYZE.FILE hashedfile STATS to report the sizing statistics then use the Hashed File Calculator to get a recommendation on minimum modulus. You only have two choices for hashing algorithm (sequential numeric keys or other keys) so that part is not rocket science.

The equivalent command for option 4 is LIST.READU. I will have to research the equivalent command for option 7 but am not doing DataStage work this week.

1. Only for jobs in which there is a Lookup File Set stage. 2. Probably, but they don't seem to be. 3. Apparently not. One might also wonder why they are placed in the system temp directory, rather in one of the directories specified in the configuration file. Have you reported this behaviour to you...

Redirect stdout and stderr to /dev/null

Does the DS.TOOLS option give you anything at all?

The point I was trying to make is that MS1256-WIN2K-CS is (clearly) a map intended to be used on a Windows machine. You need to find out what the appropriate map name to use on a UNIX machine is.

Yes there is, but it's really ugly (do you know how to unnest multi-valued fields, for example, or access data in undefined columns?).

Even though it's deprecated, you may find this an easier task in the Reporting Assistant, concentrating on the DSColumns table.

Two Aggregator stages - one to form the groups and the next to count them?

Currently no. The "diff" tool you request is in the next ("Hawk") release. But it's not automatic - you have to ask for a comparison to be made.

Kenneth, so are you saying that we can choose when creating a data set whether we want it persistent or not? Where can we make that choice? You don't get any choice. If you create a Data Set - using a Data Set stage - then it's persistent. Only running jobs create virtual Data Sets. You can inspect...

The default test utility (in branded_odbc) accesses DBF files. It's definitely do-able, once you've created a DSN to point to it.