DSXchange

cat filename | tr -d \n

The tr command strips newline characters. Otherwise you could strip them when using the activity variable.
Activity.$Output<1>

The Teradata TPUMP utility expects the log table to be empty. It's not a DataStage requirement.

Download EtlStats from Kim Duke's web site.

At design time it depends on the stage type you're using, but look for a property called something like "rows per transaction".

You first need an Iconv() function - two actually, to get the incoming data into DataStage internal format. Only then can you successfully use Oconv() to change to the desired external format. Oconv(Iconv(Field(InLink.TheString," ",1,1),"DYMD"),"D-YMD[4,2...

The advice to telnet stems from the fact that, at most sites, this is the only way you can login to UNIX. If you have directly-connected asynchronous terminal lines to your UNIX machine you certainly may use these without the need to use telnet. Either way you are talking to your UNIX login shell, p...

It's the same as in all earlier versions.

Not quite.

The next value is stored in SDKSequences (note different casing).

Although the routine checks the VOC file, it does not store anything there.

There's only one "trick" with metadata - get it right.

Access violation is an attempt to refer to a memory addrss either that does not exist or that your process has no right to access. There are myriad possible reasons, too many to essay to describe here. Search, both here and in web search engines, to get some idea of possible causes. And contact your...

It is not possible to prevent the stop request from being cascaded. However status information is recorded in the Repository, and can be retrieved even after the job has finished - irrespective of its status. Therefore your job that collects the statistics could be rewritten to run independently (pr...

A stored procedure invoked from a Dynamic RDBMS stage must process a record set.

The only way (without "leaving" DataStage) to call a stored procedure that does not process a record set is to use the Stored Procedure stage.

With a non-exact-match lookup you are destined to receive more than one row returned. Each will satisfy your match criteria. I can only answer your question with a question - which of them do you want to keep?

The first argument of DSExecute must specify a UNIX shell, not a UniVerse shell.

You are getting "not in VOC" because you are trying to execute in the DataStage (UniVerse) environment, not in the UNIX environment.

The tool labeled "A" in the toolbar is the same. Think of it as an "on-off" switch for visibility of Annotations.