DSXchange

Is there anywhere (e.g. a routine, a Terminator) that might have issued a stop request?

Any query on UV_SCHEMA that touches every page would do, or you can use UVFIXFILE or fixtool (not in fix mode). There are only as many entries in UV_SCHEMA as there are projects, so listing the entire table is only going to take one or two screens.

... provided you include "not installed at all" in the category "not properly configured".

First check whether UV_SCHEMA is corrupted. It may not be, in which case there is no cause to do anything with it. In any case the six tables in the CATALOG schema are managed differently from all others.

How did you determine that the user is a DataStage DBA as you asserted?

A Search for "does not fulfill the sort requirements of the downstream operator" will prove beneficial.

Two row generators - one for dates, one for times. Join (full outer). Add surrogate key.

Ray, this is a PX installation and those ports are closed between client and server. Or do you mean runtime port usage on a single machine? These ports are not used between client and server. Port #10000 is used between conductor and section leader processes on processing nodes, ports #11000 and up...

It's a Teradata command, not a DataStage command. Because we don't know all the identifier names in your Teradata installation, we can not help. Ask your database administrator (DBA) for assistance on Teradata command syntax.

There is also a bug is some specific 7.5 versions (maybe 7.1 as well) that prevents traversal of the tree structure for more than two levels.

What did DataStage respond to your SETFILE command?

FORGET Information Server and WebSphere Application Server. Except that they have to be running, they are not related to the present issue.

Try the telnet without the colon character.

Welcome aboard.

In addition to what Arnd posted, I would recommend that you create re-usable components (Routines or Transforms) for particular checks.

For example to check for signed integer:

There are two DVDs that are available from DSXchange Learning Center - one on Pattern Action Language and the other on creating rule sets. But I agree with JRodriguez that most of what you appear to want to do can be accomplished out of the box.

nayanpatra wrote:I am currently trying to insert data into Teradata Mload table. It's working fine. But what should be the BEFORE CLAUSE that can be used so that the table may be truncated or deleted or released before it starts processing?

The correct command to clear that particular table.