DSXchange

The limit is actually a stage property, but one that is not exposed in the GUI any more. In a server Transformer stage the total connected links must not exceed 128. One primary input, N reference inputs, and (128-N) outputs (including reject output). I have not checked whether the parallel Transfor...

APT_CONFIG_FILE was not set. What could be clearer? Bring $APT_CONFIG_FILE into your job as a job parameter, set its default value to $PROJDEF. Make sure that the pathname given for this environment variable in the Administrator client is valid. To test, use a hard-coded pathname in the job paramete...

WHAT error?

Currently the question is "there's a red light on in my car - what's wrong?"

We need better information than what you have provided to make a cogent diagnosis (and not waste time guessing).

Then mark is thus in the properties!

Tip: Be systematic with group membership.

Tip: Always set UNIX umask to 002 for DataStage developers.

There are three repair tools that need to be applied after an O/S restore. VERIFY.SQL to repair the DataStage/SQL system tables. UV.ACCOUNT will need to be updated with the new project location. Each indexed hashed file in the project will need to be updated with the new location of its index direct...

My guess is that the Aggregator stage is running out of memory. Are you using sorted input for this stage? If not, try it. It does help.

See what you can learn when you read the manuals! Yes, it's a limit in the Teradata Enterprise stage.

In the Inputs link to the Sequential File stage, on the Partitioning tab, you have specified to use Sort Merge as the Collector type and have specified CATEGORYTYPEID as (one of) the column(s) on which to preserve sorted order - however, the columns list (schema) on the link (the virtual data set to...

Change the data type of this field in the Sequential File stage from Date to VarChar(10) or Char(10). You can then extract the day number and month name using Field() function (especially if the day number may contain one or two digits) or substring (if the day number always contains two digits). Co...

HOW has "problem been resolved"?

Please assist future searchers.

Try it and let us know. Ideally in a new thread - not everyone visits Resolved threads.

In short, CLASS not CLASSID. Tip: _ Where the error message occurred, the query parser has indicated the token at which it had stopped, in this case CLASSID. And it's reported that that is an unexpected symbol. So you go back to the metadata to determine the correct name of the symbol, which you did.

What stage types? From the error message it appears that the interlude to the getpid() GCI call has become corrupted. Can you look at that VOC entry in this project and another, to see whether they are different? Timed out can be due to many factors, including database locks; this is difficult to di...

That's the stage OSH, not the record schemas. Record schemas begin with -record and contain column definitions enclosed in a pair of curly braces.