DSXchange

Yep, and that's what the Lineage Analysis capability in MetaStage can provide. Haven't played with Information Analyzer yet, but suspect it can do something similar, given that the repository database is based upon the MetaStage hub!

ARE views partitioned? If not, then searching for them in the system tables is pretty much guaranteed to fail, hence the error message.

DB2 or Oracle Enterprise stages support sparse lookup.

An Exception Handler can be connected to anything. The Exception Handler may be triggered by failure of an activity for which no explicit failure handling is provided. An Exception Handler can only have an output, never an input. It is analogous to a signal handler in C. A Terminator activity can be...

Looks like you've described a VarChar column somewhere but forgotten to supply its Precision (maximum size).

Release job functionality is the old way to promote jobs into test and production. It was old hat, and replaced by Version Control, before parallel jobs came on the scene. It was kept for server jobs solely for backwards compatibility.

There are eight system tables to which you require SELECT privilege. It helps to remind the recalcitrant DBA that you can not do any damage with only SELECT privilege.

Does LD_LIBRARY_PATH include branded_odbc/lib ?

Stage variables' scope is only within the Transformer stage (and therefore in its process). Similarly, any variables defined as COMMON in the Transformer stage are only accessible in its process; that is, in a before-stage or after-stage subroutine invoked from that Transformer stage itself, or in t...

If what you want to do is keep only the alphabetic component, apply the LETTERS Transform.

Otherwise remove the "*" (and "-" ?) characters with Convert(). Then use Ereplace() to remove the 100. Use Ereplace() again to remove the residual parenthese from the Trim() of the prior result.

Welcome aboard.

On Windows you will need to have an SMTP client. These can be sourced from the web; blat is a good one.

The error is being generated by Sybase. Ask your DBA about it, particularly about the meaning of error code 131. Somewhere something is running out of memory.

Auto purge setting applied in Administrator does not affect extant jobs; it only affects subsequently-created jobs.

There is nothing out of the box to globally change purge settings in existing jobs. I've certainly written one, and you can download one from Ken Bland's website.

Suppose rows/sec were even a meaningful metric. You could boost the rows/sec figure simply by using shorter rows.

Pope Gregory shortened October of A.D. 1582 by ten days. Thursday, October 4, 1582 (Julian) was followed immediately by Friday, October 15, 1582 - see this site for details. My routine handles this situation, because the underlying "UniVerse" date handling functions are aware of it. But it would app...