DSXchange

Exanine the score (set APT_DUMP_SCORE to True). It may be that DataStage has optimized the copy operator out of the design. That would certainly explain no row count being generated on its output. A Copy stage with one output and unchanged metadata is effectively a "do nothing" stage, and the optimi...

First, you need to buy DataStage Enterprise MVS Edition licence.

You can't delete things that are in use (for example open in Designer or Directory Log View).

Preserve blanks only preserves blanks that are already there. "Randy" does not have any blanks.

Get to a UNIX prompt and type man signal or obtain a basic UNIX book to learn about UNIX signals, of which SIGINT, SIGKILL, SIGBUS are a few examples. Each has a particular purpose.

Doesn't Search work for you?

Well, TPump is designed for "trickle feed" taking individual row-level locks. Obviously it's not going to be as fast as MultiLoad or FastLoad, but if you've got no utility slots left ( ) it's a good choice. How fast it (TPump) can trickle depends largely on your Teradata server configuration and how...

And it's already an enhancement request (by virtue of being posted here)!

The *.adm files are not executables; each contains a list of group names associated with that particular DataStage role. It's read by dsrpcd when a client attempts to connect.

No, here is a good place. Have you tried placing the *.adm files into the Template project? If so, do they get copied into newly-created projects? Beware that the *.adm files must be writable only by the DataStage administrator, but must be readable by all.

TPump does not take a utility slot.

Therefore you can use the Teradata Multiload stage, and select TPump in the Load Utility frame (bottom left of window).

Shouldn't the aliases be on the tables, rather than on the fields?

DBA is out on a training program and I only hope he is not paranoid. This is another gripe of mine. They back up their data - why don't they back up their skill sets?!! If the DBA is suddenly unavailable (let's say hospitalized, without wishing this on anyone), who performs the DBA functions? Skill...

Oh, a DBA must be somewhat paranoid - you couldn't do the job well otherwise. The DBA's motto is something like "user is a four letter word". But there is the odd one who takes things to extremes. Often, in my experience, ones with mainframe backgrounds. Good DBAs know how easily they can make life ...

Your friend will need to send you the relevant lines from the original DSParams file.

There is no other way. Apart from them documenting the values and you entering them manually, of course.

Source: private conversation at Information on Demand 2006 Not aware of any documentation. The mechanism to find the start points for each reader is to position to the, say, 25% point then scan forward until the next record terminator is found. That's the start point for this reader and the end poin...