DSXchange

I would not think so. RCP is an all-or-nothing deal.

My guess is that that SQL will throw a syntax error of the form "avg function used with no grouping column". This has to be a nested query.

While grimm336 tries to remember, use the Administrator to check whether the indexes are intact. Execute the following commands. In particular note the setting of the "Build Reqd" column.

Abs() works - provided that the argument is numeric and not null.

In particular check the code page being used by the database(s). Compatible code sets (map names) must be used throughout.

Does the db2nodes configuration file have the same number (and names) of nodes as does the parallel execution configuration file? Are you working in a DPF environment?

Size is given in the Output Format column for "D" and "I" type entries. Here's the listing from the DS_AUDIT hashed file. Type & Field......... Field. Field........ Conversion.. Column......... Output Depth & Name.......... Number Definition... Code........ Heading..........

Where you have " X " do you need to convert to a single space (use Trim() function) or only to remove the X (use Convert() function)?

Probably a bug (if what you say is true and reproducible), and definitely 7.5x2 (because it's actually running). Contact your official support provider or search Fix Central to see whether there's a patch for this.

gooogle wrote:I created a job but it needs to be started only with a Perl script on a windows server.

Why?

gooogle wrote:Please help.

Resist stupid requirements!!

And this means, in turn, that you really should design in a mechanism through which you can request an always-running job to stop, for backups, etc.

The convention here on DSXchange is, when you mark a thread as resolved, you make a post indicating how it was resolved, to aid future searchers.
Please do so.

The convention here on DSXchange is, when you mark a thread as resolved, you make a post indicating how it was resolved, to aid future searchers.
Please do so.

... provided that a VOC pointer exists for the hashed file.

Not really. But a Link Collector stage will perform the function that a Funnel stage performs in parallel jobs.