DSXchange

Sorry but can you please tell me how to check this ? COUNT DS_JOBOBJECTS USING DICT VOC The same way you executed COUNT DS_JOBOBJECTS - probably through the Administrator client window. This command will not generate any error about D_DS_JOBS (which can come from a query against DS_JOBS, but not fr...

Welcome aboard. Can you please re-post your question in the Enterprise Edition forum, which is specifically for parallel jobs? The forum in which you posted (FAQ Discussion) has a rather different function, which you can review on the Forums index page. *Note: Topic relocated - Content Editor*

I wonder if this is related to the known bug in which range lookups work for numeric data types but not for string data types?

Alas I can't help with a solution.

There are probably other problems. Check DS_JOBOBJECTS for integrity using UVFIXFILE or the fixtool utility. Or COUNT DS_JOBOBJECTS USING DICT VOC might also work. Also find out which job belongs to job number 1279 ( SELECT * FROM DS_JOBS WHERE JOBNO = '1279'; ) Reindexing is unlikely to be needed a...

Experiment. Your results may be different. What dineshrk has suggested might be true on one combination of hardware and not on another.
Post your results so that others can benefit.

Remember that it is Display Width that specifies the field width, not the data type.

Welcome aboard.

This is not the appropriate place for this question. TX is no longer a part of DataStage nor is it an Information Server product. Please re-post your question appropriately, probably in the General forum.

Probably, provided that they are identically defined to the node names under which the Data Set was written. And I do mean IDENTICALLY.

See previous answer. Buy premium membership if you can't see it all.

(1) (a) To process the files one at a time. In a job sequence create an Execute Command activity to list the files. Capture the output of this command via the $CommandOutput activity variable. Convert the line terminators (@FM) to commas and supply that as the "list of things" in a StartLoop actiity...

(2) The obvious things to do in a server job are:

set "First Line is Column Names" in the Sequential File stage

add a Transformer stage output constraint @OUTROWNUM > 1 (this will cause DataStage to ignore the first row remaining after the column headings row has been removed)

Tell whoever told you to do this that it's not possible to sum CHAR data types. IF you can guarantee that they will contain numeric values, then you can treat them so but you will need to apply an appropriate conversion, such as AsInteger() function, and then sum the INTEGER values. It remains the c...

There's this great utility called the internet, with a number of different search engine available. Each database vendor has its own web site, and there are companies such as Gartner Group that specialize in these kinds of comparison. DataStage tries to be as agnostic as possible about data sources ...

You're missing what it's telling you: A fixed length field cannot have a "null_field" of length 0 on import with delim of none or whitespace.

You must provide Null Field Value property values that contain the same number of characters as the defined field width.

Does this occur after you reset the job? There is no "template" used for dsjob. Wave number is an internal number used by DataStage to identify unique runs (for example a reset run or multi-instance runs).

Generate a Key Change column in the Sort stage and apply a constraint in the Transformer stage that this column has the value 1. Or simply specify a unique sort.